Over 1 million tech questions and answers.

Database Help?

Q: Database Help?

Hello everyone, I am wanting some help on the best way to set up some sort of database/spreadsheet/form to help our business please. All we are wanting to know is if I enter a postcode it will tell me what agency it belongs to eg 7614 = Northshore. Is there a google form or programme that can do this ? Thanks

RELEVANCY SCORE 200
Preferred Solution: Database Help?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Database Help?

Read other 8 answers
RELEVANCY SCORE 41.2

I am just starting to us VB 2008 Express. There seem to be two different types of database I can create in it. I see something called "local database" and something called "Service-Based Database". Can you tell me what is the different between the two? I am developing the application on my computer now but I would want to have the database on the server after so multiple users can access the database. I most likely be using a web hosting company for this. Thank you.

A:Service-Based Database Vs. Local Database

A quick google search came up with this Adobe reader file which seems to have most of the answers for your question

Here is the link.

Also, to access and read this file, you will need Adobe Reader.

(Simply click the colored links to be re-directed)

Let us know if that is what you are looking for,

-Coolfreak

Read other 1 answers
RELEVANCY SCORE 41.2

Hi,
I don't support Access, nor have I been trained in it, but I've been asked if I can help in this problem.
An Access database connects externally to a SQLServer database at login time for the application. How do I find which external database they are connecting to? I know that there is a way to go behind the forms to see the source code, but I cant remember how to do this.
I cannot find an obvious User/System file dsn on the PC to give me a clue.
Thanks in advance
 

A:Accessing external database from Access database

Read other 9 answers
RELEVANCY SCORE 41.2

Hi Guys,

Im trying to write some code that will copy my access database , tables and data to a new sql server database, ive got the code to create the sql database but i need to populate it from my application

Any answers would be grateful

Thanks
Mark
 

A:Copy an access database to SQL server database using VB.NET

Google: import access to sql server
 

Read other 1 answers
RELEVANCY SCORE 41.2

I'm building a database application in Visual Basic .NET and I want to know what is the equivalent code of this when I want to make a connection to mysql:

Protected connString As String = _
"Provider = Microsoft.Jet.OLEDB.4.0;" & _
"Data Source = " & loc & "\dbProject.mdb;"

Private cn As OleDb.OleDbConnection = New OleDb.OleDbConnection(connString)

Private ConnectionString As String = connString
 

A:Exporting MS Access Database to MySQL Database

You would have to have the MySQL driver for it on the server regardless.
 

Read other 1 answers
RELEVANCY SCORE 41.2

I can't figure out how to add a column to the right of all my data. I insert column, and it inserts a column LEFT of the column my cursor is in (the very last column). And I haven't figured out how to manipulate the columns to move them around like I can in Excel (which is still a hit or miss thing for me - anyone have the tip on how to do that, too?)

A:Adding database columns to the RIGHT of the last database column

For any curious, I did find a way... You have to open design view and add it in one of the blanks beneath your last entry.

Not quite as easy as just right-click > insert, but it works.

Read other 1 answers
RELEVANCY SCORE 36.8

I need to query a table in a database that I need to write to to determine what records I need to pull from the database I need to read from.
Example(This dosnt work):

DECLARE

DateVar Date;

BEGIN

DateVar := Select MAX(Invoice_Date) from write_To_Table;

COPY FROM read_database TO write_database INSERT-
destination_table (column_name, column_name...) -
USING select * from read_From_Table where invoice_Date > DateVar;

END;

Any other suggestions
 

A:COPY FROM database TO database USING

Hi,

What you need to do is:
- Connect to write_database.
Query the DateVar for your WHERE condition.

- Connect to read_database.
Query all the records what that you want to insert to write_database.
Then store the records to "ARRAY"

- Connect to write_database.
Insert your "ARRAY" to destination_table

I hope this helps.

Red
 

Read other 3 answers
RELEVANCY SCORE 33.6

I have MS Access 2000. I initially created a long book list several years ago. I recently found a template from the MS database for books that I downloaded that I like better. I have tried importing the data from the old database to the new one but with no luck. Both are in Access 2000. I am running Win2K.
Thanks
 

A:Transfer from Access Database to Access Database

Read other 6 answers
RELEVANCY SCORE 29.6

Hi everybody I am looking at making a new game and I need a database software to store all the information I need to be able to make the game I am just after a bit of information on the best type of database software to get

Thanks for any help
 

Read other answers
RELEVANCY SCORE 29.6

Could you help me answer this one: What are some disadvantages and advantages of hiding complexity from the user of DBMS
 

A:Database

If this is for a test I choose A, none of the above.
 

Read other 3 answers
RELEVANCY SCORE 29.6

A few last questions...

How can I put a GUI for the many to many part of my database. Also how to get the multiple addresses to show on the form. You can download a generic vs of the database from http://forums.techguy.org/business-...ved-listbox-controlling-subform-access-2.html.

But I would also like to add, this isn't the version that will be the final, that is on another computer and there's already passwords and all sorts of good stuff on that one, so I really can't upload it, not to mention I don't have a way to transport it anymore lol My poor flash drive decided to die this morning.
 

Read other answers
RELEVANCY SCORE 29.6

I have all my customer information in a database program called Maximizer CRM 11.
I inherited this info from another worker.
I would rather use Microsoft Access. I am thinking that I can export the Maximizer database to a csv file. Will that include all the fields and can I import this to a new Access database?
Is it a seamless transfer or is there more I need to know to accomplish this?
Thanks for your help with my project.
 

A:Database help

I am sure it can be done, but you need to know what the relationships are between the different tables in the CRM so you can replicate them in the new database. If there are forms you will also need to replicate them on your own to display and manipulate your data. There is a lot more to it than just importing the data.
 

Read other 1 answers
RELEVANCY SCORE 29.6

Hi there,

i'm new to databased so i apologise if this is really easy.

i have a database where i have a department in 1 field, member of staff in another and a grade in the 3rd (ranging from 1-4). How do i get a query to add the amount of 1's then 2's etc per department?

Thanks for any help
Phil

A:Database Help

SELECT COUNT(grade)
FROM Department
WHERE Department = HR (for e.g.) AND grade = 1

I don't really get what you mean, so this query actually count the number of grade = 1 in HR department.

If I got you wrong, let me know and I can change accordingly.

Read other 2 answers
RELEVANCY SCORE 29.6

Hi all,

I have a project at work that is still in its planning phases, and I just want to understand what I'm up against.

We have a huge RedBrick database that I am going to have to run custom SQL queries against to produce some ad hoc reports for our business execs.

What tools do I need or should I ask for to accomplish this? The only SQL experience I have is running queries against a local SQL Server db from the SQL Server enterprise manager. So connecting across the network is new to me, and I don't have SQL Server available to me as a tool. Can I accomplish what I need with MS Access?

The engineers gave me the information I need to set up an ODBC connection, but I'm not exactly sure how to go about doing that. Do I do that from within Access? Where does my login name and password for the database come into play in setting up an ODBC connection?

Lastly, the schema for this database is friggin' HUGE!!!! There are approx. 58 tables in this db with millions of rows in each table. I've never constructed a SELECT statement for a schema quite that complex. What is it going to look like?

For instance, the db's name is usage. It has tables brand, customer, sku, contract and advertiser in it (for example). What would a query to pull all rows from those tables look like?

Thanks in advance for all your help,
Richard
 

A:I need some database help please

Read other 12 answers
RELEVANCY SCORE 29.6

I need Someone to Help Me To creating Access Database for my company
 

A:DataBase

That's pretty vague, any more details? If it's a complex or important database for company use you may want to hire a programmer that will provide continuous support, updates, and troubleshooting.
 

Read other 1 answers
RELEVANCY SCORE 29.6

Hi every 1

we have an sql server 2000 it installed before 2 years on windows 2000 advanced server.Now it's database size is 4 gb.My pbm is that when i try open last month or last year record from client machine it takes 15 to 20 minutes to opening the records.during that time the client machine is busy fro 15 to 20 min.We can't do nothing till the operatin is completed.Also entries from client machine also working slow.After I shrinked and reindexing the database it working normal for 2 or 3 days.But after that the same pbm occured.Any way to permanently solve the pbm.When i want to see last years records it will show withing a minutes.Plz help me.

Tahnkx.
 

A:Sql Database Pbm

Hopefully, you know relational theory and have 'normalized' the data.
When a given table gets too big, a typical solution is to export portions into
new tables with a 'fixed value' column, eg: year. If the size of the year-table(s)
are still too large, the next solution is export into second database.

DBMS startups can be costly -- the indices get read and memory structure are build.
Primary index will have only one entry per row of the table (by definition).
Your secondary indices can have many entries per table row.

Consider DROPing all secondary indices (they can be rebuilt later) and restart the system.
If this has a major improvement, then you know that you should consider
which indices you actually need and rebuild each and restart to see the
impact. When it become 'too costly', the last index is your problem --
consider why you have it and how you use it.
 

Read other 1 answers
RELEVANCY SCORE 29.6

Hi

I have recently created a database which contains data centred around projects. Sometimes these projects are carried out by one department and that's very straightforward but often they can involve 2 or 3 different departments. There are various types of testing within each department and each study. How do I go about setting up the database to take all this. I'm thinking that maybe i need to create a many to many relationship - is that right? If so this data will have to sit in a table outwith the main "projects" table. Will I be able to create a form where I can enter all the data so that the main project data (which tends to be fixed) and this multi test type data can be entered or will i have to enter it separately into the 2 different tables.

Jacki
 

Read other answers
RELEVANCY SCORE 29.6

Recently trying to clean off a server a database was deleted, before the delete a backup was made of it. After the database was restored, there was a excel document that used a vb button to refresh data, and now when you click it you get an error message.

could not find database id 13. database may not be activated yet or may be in transition.

also when you click debug the line it points you to is: rs.open sSQL, db, adOpenForwardOnly

This wouldn't be a problem with the vb, that hasnt been changed, what do i need to do with the database to get it working with this?
 

A:sql database

You need to look for the connection string in your VB code and that will point you in the right direction. Look for a db = variable in your code.

After restoring the database does it run and can you access it by other means like ODBC or SQL manager?
 

Read other 3 answers
RELEVANCY SCORE 29.6

I am looking for some type of database that we can insert short filmed interviews into as well as pictures. Does anyone have any suggestions? Entering a new and different area for me. Any suggestions welcome.
 

A:Need database

Read other 9 answers
RELEVANCY SCORE 29.6

I don't really understand how databases work. I'm learning ASP, and I know it's very good at reading and writing to databases, but I have no clue how to set it up to do so. I don't have a database set up or anything, and I don't know how to set one up. Any help appreciated, or tutorials. Thanks!!

Sorry about being so vague.
 

RELEVANCY SCORE 29.6

Hello .
i hope this is the right place for my questions ..
here we go .
I have a huge music library that i have been putting together for about 24 years . its just outta control stuff all over the place . cd's , vinyl , 8 tracks , cassetts ,minidiscs , mp3's, ect...
on the otherhand I have a nice "LOG"i have been working on of 1 genre - the name of the artist , album name , release date ..
i have been working on that for quite sometime .. now i would like it to be searchable ..
basically have all the artist names , album names & release dates stored into a file.
what i would then like to have is a user interface to be able to search an artist ..
and then display the results ..can you programm masters send me in the right direction so i can make a nice searchable "Database" i guess its called ?
thanks a million .
MGT :
 

A:[help] database ?

Read other 9 answers
RELEVANCY SCORE 29.6

hello,

i'm doing a database project where i need to create a initial window for user login form with user name and password, for which i have decided to use a graphical password(that is, clicking a set of consecutive areas in the picture will determine the password).
i'm using oracle 9i as a backend and c# as my frontend. Is there any provision using which i can implement it easily. . .

thanks

techian_cool
 

Read other answers
RELEVANCY SCORE 29.6

How do I clean out all the files in My SQL Database that I am no longer using?

TTIA :)

Read other answers
RELEVANCY SCORE 29.6

Hi,
I have a large data base for which I have an excellent application search engine. It called AskSam Pro and is for PC only. What I need is something similar that will work on Mac platform. I need it to import & export form MS Word & other apps while keepig the format of the doc. Be able to search over the 800 doc (27MB0 by single word or phrase or boolean and show the list of docs by date and number of hits. VBe able to import & export individiual docs in Word. and do this with a free style entry form (in other words I can design the entry form of the documents to fit my individual needs). The app that I use cost only $100. But I can go higher if need be. It is VERY user friendly and has a low learning curve. That would also be good in this office as some peoplehave less than average tech skill.
Any help would be appreciated.
 

Read other answers
RELEVANCY SCORE 29.6

Hie everyone

Please help, I have to come up with a database of students that will be able to track the students' progress,i.e how many passed,failed, how many passed after first sitting ,after a resit etc. The thing is this has to be viewable(if such a word exists!) in a website sort of environment. People should be able to log on in some form of browser and still be able to view the data. am not a very advanced developer therefore need help with the following : Is there any application like I was thinking Visual studio or something like that where I can combine both web and data development in one? Or do I have to do the db and website separately then combine them later if so how????? Thanks
 

A:database help

Read other 6 answers
RELEVANCY SCORE 29.6

Hi crew!

I need some info:

In web development I came to line where I MUST choose which server side language to start learning... PHP or ASP (now ASP.NET option).
I know PHP is for all sistems and ASP is win based.

Also regarding databases:

MySql or SQL Server
...because What if database will have 200.000 or 1milion user. Just tell me where is BORDER when I should use SQL Server instead of free MySql?
Example if you will have more then 100.000 user then use SQL Server.
If belove 100.000 use MySql
 

A:PHP or ASP(.NET) ...which database?

Who is paying for the SQL server?

The license is in the tens of thousands per microprocessor. This include dual core microprocessor which have to pay double license.

It is all matter of your wallet size, fear factor, and CEO bias.
 

Read other 3 answers
RELEVANCY SCORE 29.6

Greetings to all,

I'm currently having trouble with using Microsoft 2003 Database. I've got to do this task by 8am today, which is in 3 hours, and I'm stuck with this section of exercise from University.

I've also got a test based on this in 4 hours, so I'm gonna need a quick asistence on this one as soon as possible.

Task is this:
"Currently, when you select the Video Code drop down box to enter a new rental, all the possible rentals are listed. In this section, you will limit the list to only videos that are able to be hired.

1. Select the Row Source property of the Video_Code in the Video Rentals subform. Cick on the ellipsis and as you do you will invokde the query builder on the Video table.

...so on."

I cannot find the ellipsis or Row source property in the subform section. I could possibly post the data up, etc but that'd be too confusing. Guiding me with some screenshots would be wonderful.

File is downloadable at: http://www.yousendit.com/transfer.php?action=download&ufid=45E9288010A1E3F5

The section I'm stuck with is in the 4th page of the pdf file, could be also called page26 at the bottom of the page.

If anyone could possibly help me directly on MSN, that'd be just amazing. I also might need more extra help later on, so if anyone free could help me on MSN, would really apprciate. Note: Got to finish it in 3 hours.

Regards,
Maverick
 

A:Immediate Help with Database

Read other 6 answers
RELEVANCY SCORE 29.6

I am a drafter and i would like to build a db for all the drawings in our system (aprox.5000). This would not have multiple access at one time. It would just be a local file on my computer. The db would consist of all the drawing numbers. drawing titles, revisions, revision dates etc... and each time the drawing is revised there would be a new description and project number added. I know that is a pretty basic overview but I hope it is enough. What I would like to know is what db would be the best for this.
 

A:best database

MS Access would suit your needs.
 

Read other 2 answers
RELEVANCY SCORE 29.6

I can't access my Act database from other accounts other than my Admin account. I keep getting an error of: dependentdlls.xml is denied. What do I need to do to make this accessable on other screens?
 

A:ACT Database

It is a user permission problem, the link below from the software maker should cover it.
http://itdomino.act.com/act.nsf/c8a...59b993f8dae43f810725718d0068b09f?OpenDocument
 

Read other 1 answers
RELEVANCY SCORE 29.2

I recently made a copy of a database, then secured the original. Everything went fine and the "new" database works well with passwords, etc. But this new one is 18,600 kb larger than the original. Anybody know why? Everything appears the same as in the original.
 

A:Shrinking database?

Read other 7 answers
RELEVANCY SCORE 29.2

Hi
I am running a Lotus Domino 8.5 server on Centos 5.2 x64 Linux. The installation is on a Intel server with Adaptec RAID controller 1.7Tb and the Notesdata directory is on an external Dell PowerVault MD1000 5.5Tb with RAID 5 configuration. I also have LVM2 installed.
On Wednesday last week we had a power surge. I have 2 x 3KVA UPS installed, but for some reason the external Powervault RAID lost the connection to the hard drives. After i rebooted, i check the RAID BIOS and found that 1 drive failed and the RAID is rebuilding.
After the process completed, i started up the server. FSCK gave me error that the volume is inconsistent and i should run fsck manually. So i ran fsck -y /dev/VolGroup02-LogVol02
This ran for almost 10hours, and supposedly fixed hundreds of errors. Once the server booted up, the file system was mounted as read only. I tried unmounting and remounting the volume, also checked fstab for valid mount points.
fdisk -l stated that the volume does not contain a valid partition table. So i bought 3 x 1tb drives and started transferring the data. I cleared and re-initialized the RAID and created a new RAID5 config.
This time i created a GPT partition table and formatted the file system to ext3, transferred the data back using Krusader and preserved ownership and permissions.
I ran an offline fixup, compact and updall.
I then fired up the Domino server to find that my names.nsf is gone. So copied one from a backup server. On startup i found many errors about files... Read more

A:Why file is not a database?

This sounds horrendous. I'm at a loss on this one, if it's gone, it's gone, that's why I backup all my data to cloud servers with unlimited storage which are a foolproof backup system .Maybe the best way to go in future. Sorry bud.

Read other 3 answers
RELEVANCY SCORE 29.2

Does anyone know what type of database file PacSoft POS uses? I just want to evaluate Crystal Reports and Pacsoft for a local business. Specifically I would like to have a sandbox database (small) to use while developing reports for this business.

Thanx!
 

A:PacSoft database

I've done a little more research and it looks like the format might be Foxpro or Halcyon. True?
 

Read other 1 answers
RELEVANCY SCORE 29.2

I have an issue with an access database. When I print out a report one of my columns only prints out 4 out of the 5 digits. This happens with 2 machines. On other pcs the 5 digits appear in output of the report. I have checked the resolutions of the pcs and they are the same. I cannot figure out why only 4 digits appear out of the 5.

Can anybody help?

thanks
 

A:Access Database

It may be the version of True Type Fonts that are involved, can't you just increase the column width slightly.
By the way you getter better responses for Access/Excel questions on the Business Applications Forum.
 

Read other 2 answers
RELEVANCY SCORE 29.2

i am creating a database app. i would like to create a dropdown list of all the available fields in a particular table for the use of filtering data (adoObject.recordset.filter). i know that i want to fill the dropdown list in the form load event but i'm not sure how to get or retreive the available fields to fill the list. i have been able to fill lists with info from any one field, but i would also like to fill a list with all the available fields as well. anyone have any suggestions for a beginner such as myself???
 

A:database fields in vb 6

You need to use something like this:

Private Sub Form_Load()
'Create the recordset
With MyRecordset
For intField = 0 To .Fields.Count - 1
Combo1.AddItem MyRecordset.Fields(intField).Name
Next
End With
End Sub

This uses the fields collection of the recordset to populate the combobox.
 

Read other 2 answers
RELEVANCY SCORE 29.2

Hi all and a Happy New Year.
Right let's get back into the swing of things.
I am running WSUS on a Windows 2003 Web Edition.
WSUS comes with the free Microsoft database not SQL Server
My question to you all is!!!

Is it possible to access the database files the same way you would do a SQL Query?

I've got a copy of the WSUS Data files and i'm looking into extracting only the data i require from the files, rather than printing out the very good report that is generated by WSUS.

Any ideas welcome

MarkyB
 

Read other answers
RELEVANCY SCORE 29.2

Hello!

I am trying to create a database to allow me record serial numbers for each product that is made. What I am trying to do is get it so that with each serial number, you have drop down boxes. For example:

I have 5 companies
Each company has 7 product types
Each product type has got 8 products in it

When I am entering the serial number, I want a drop down list with the different companies, once a company is selected I want the Product type to only show those products relevant to that company, then finally I want the products drop-down to have only those products relevant to that company and that product type in it. Is this possible?

Many thanks in advance

Tim Underwood
 

A:Database Construction Help

Tim, there are a few Database Threads that I have answered that have the same sort of requirement as you, although some only have 1 dependant Combo Box.
So if you use the Advanced Search to look for "obp" you should find some.
If not come back and I will assist you.
 

Read other 1 answers
RELEVANCY SCORE 29.2

If one were to endeavor to become fluent in one of the most in use database software programs, which would one chose to maximize chances of employment?
Access? Oracle? DB2?
Thanks and have a good one!
 

A:Database question

they all have there place dont forget about SQL
have a look at some of the jobs advertised - do you want to be a programmer or DBA
 

Read other 3 answers
RELEVANCY SCORE 29.2

I installed the game Maple Story on this computer, since it's about the same specs as the other one I use, but when I start it up, the Search function comes up and says that the file "Database" is missing. Anyone know how to fix it?

Also, wasn't sure if this went in the games forum or XP, but this also happened when I tried to update Directx, so I put it here.
 

A:Cannot find Database?

Hi mate!

The best place to post your question would be the games section of the forum. So you may want to repost there for more help.

However, since you already made a post I suggest that you uninstall maple story and delete the folders it created. Then try reinstalling it. I guess that the installation became corrupt somehow. If you have time try re downloading the maple story installer and reinstalling from there.

Did your problem start after installing DirectX? This could be just a coinsisdence, you can get the latest DirectX from Microsoft's website and reinstall it as well just in case.
 

Read other 3 answers
RELEVANCY SCORE 29.2

Hi there,

Anyone know of a good book that has all(or close to it) of the database commands that Access 97/2000 would use?

Just a good reference for query commands, misc definitions and terms, ect ect.
Thanks for any input.
 

A:Database Information

This looked interesting...
http://www.adlandia.dk/amazon/windows/access-uk.htm

------------------
~dreamboat~
Brainbench MVP for Microsoft Word
Brainbench
 

Read other 1 answers
RELEVANCY SCORE 29.2

I have a growing list of customers with there details and reference to the paper form of the invoice number along with the cost of the service.

The receipts are in paper form and contain information such as the service performed, the way paid, when the service was started/done, customers signature, and the costs of the service.

I would like to have a database either via online or software to purchase that will be able to just keep the customers contact information along with the ability to view order numbers and dates associated with them. Example - I look up John James and it shows on 05.05.08 he had a service performed and it shows that the invoice# is 125. This way i can know where to pull this up and in what time frame to look for in my filing cabinet.
So the database has to be able to :

1. allow me to add/delete customers
2. allow me to view all the customers and there details (address, #)
3. view reports which will show me things such as the amount of customer in one zip code or the annual income from all invoices totaled
Do any of you have a recommendations on software or whats the easiest and most cost effective way of handling this?
I might want more than 1 person be able to view this in the future (thus my thought on online database with user credentials) or i was even thinking of making an access database.
 

A:Recommended database?

Read other 6 answers
RELEVANCY SCORE 29.2

Hi,
I have an MD who has finally got round to asking for an old database be brought into the 21st century.

It was created/written back in the days of windows 95 and works 4 etc, in DOS, from what I can gather the program works extremely well for what it is supposed to do, and from what I can fathem out, the main files(s) are in a .DBM format.

DBM I believe is database manager - the file(s) are 1.05MB and 1.425MB's in size, from what I have determined, the option to save in a format like de-limited text (CSV?) is not possible.

The question - is there a recomended software that can read this format and then convert it to CSV so that can be transfered to excel then on to access or any step in between, the PC is so old that the only way to remove the data is through a 3.5" floppy disk or manually input via screen to screen or print a hard copy (vista pc's will not network through to this compaq through it's network card, nor have I tried to fit a usb card - on a 3/4 full 600mb hard disk there may not be sufficient memory to allow for any additional equipment).

Would I need to move the whole program including the bat file or could I just use the .DBM file?

any thoughts would be appreciated

phil
 

A:legacy Database

Read other 11 answers
RELEVANCY SCORE 29.2

HI,

I am looking for a program or application that can will help me to create my own contact databases. I would like to be able to copy information from web pages such as telephone directories and paste them into my own contact manager or database.

For example there are websites with directories of every golf course in the UK and I would like to grab that info and build a contact list.

Thank you.
 

A:Database builder

There isn't an automated solution to this were you enter some command that says "grab info from UK golf website" and all the address and phone number information pops into your database. You'd have to manually enter it. You can use any number of things for this such as Outlook, Excel (or other spreadsheet program), EssentialPIM. Any program that stores contact information would work.
 

Read other 1 answers
RELEVANCY SCORE 29.2

I have a working Access database on a machine running WIN XP and MS Office 2003. I transferred that database file to a new machine running Vista Ultimate and MS Office 2007. When I try to open the database on the new machine, I get this message: missing reference dao2535.tlb. How do I resolve this?
 

A:MS Access Database

Open your database.
Hit Alt+F11.
Hit Tools-->References.
It would seem it's missing from there.

See:
http://support.microsoft.com/default.aspx/kb/824259
 

Read other 2 answers
RELEVANCY SCORE 29.2

The question is,

How do I get a database (Access) to tell me when it has a new record?

I want to be emailed when a user has completed a form which is then sent to a database to be stored. Do i attach a cgi code to the submit button so when the user clicks two operations happen at the same time (cgi email and insert database record), or use some form of code that will make the database tell me when its got a new record? With either option, please tell me !!!

I'm using ASP/VBscript.

Thanks for the help ! ! !

Spu
 

A:How do i get a database to tell me when it has a new record?

Personally I would include some script in the asp page that your form calls on which would trigger the email at the same time as it does the data insert. I cant quote the code off the top of my head but I seem to recall it's fairly simple.
Cheers, Bob
 

Read other 2 answers
RELEVANCY SCORE 29.2

Im needing to print off labels of a set size from a database but i cant get it to work.

I have the database saved and i want to mark so many of the items to print off labels for without printing all of the list. Ive tried marking the few i want, hideing the rest and then saving as a new document and then importing the saved database to a label section in Ms Works task launcher but it still brings up all the labels in the complete database. How do i get it to print off just the few that i highlight?

Also the database shows a ? sign on the screen but does not print one on the label or show one in the header box at the top of the page if i click on the price box. How do i get it to print a ? sign on each label?

It probably sounds a bit confusing, but its even worse trying to get it to actually print the right thing.Any help much appreciated.

A:Stuck With A Database

Ive just found out that the database was created in works 98 but the labels are to be done in office 2003. Are the two programs compatable or will the database have to be re-done in office 2003 for it to work??

Read other 8 answers
RELEVANCY SCORE 29.2

When entering a form..the page normally start with a blank page/form..what code can I use in Macro or Visual Basic..to have the form blank..when entering the form..so that you can just add..new data..instead of having to click on add new data..
 

A:Access Database

First, this is really the wrong forum for this question. It should either be in Applications or Development. I only saw this post because I was checking on a post I made here before but I don't usualy visit this forum often.

If you want a form to open ready to take new data, set it's Data Entry property to Yes. (You'll find that property in the Data tab of the forms properties.) If I misunderstood the question, post back and give more details.

Good Luck!

[This message has been edited by YSB (edited 08-10-2000).]
 

Read other 2 answers