Search results

Actually I am running XP developer edition. :) I have helped quite a few in the past and since all version can open previous versions, I have learned my lesson on posting samples. I try to revert it to 97 so everyone can open it.

OK, to answer the questions.... The code goes behind the command button that I suggested adding to the form. Think of you form as it is, and when the user selects the second command button, this command button (third) appears as well as the new combo box and its label. The code in the open...

First, the field in the table itsefl has to have its DATA TYPE set as HYPERLINK. This is where you see TEXT and AUTO NUMBER to the right of the Field name in design view. As long as this is set properly, open the form in design view. Check and make sure the textbox is bound to the correct field...

You can always add a linked table to a database, even if its a FE/BE situation. Add any new table to the back end, then in your FE go to the TABLE selection window. You should see all of the linked tables in there, now select NEW and then LINKED TABLE. Once you add the link, you cam manipulate...

Ok, I will do my best to break this down. First, create a query that retrieves all of the sales persons IDs from your table. Just create a basic select query, and use only the sales person name field from the table. Then click on the TOTALS selection on the toolbar (looks like a Greek E or a...

You could do this if you have some sort of field refrence to the sales person. There are a few options. 1) Add to your existing form a combo box from which they could select thier name. 2) Refrecnce the log in ID of the OS through VBA and compare the returned value vs a table of associated...

When you spilt the database you essientially create two databases from the one. Open up the BE as any other database, and you can make all of the modifications you want.

It would be much better to use queries, and append the data to the second table if possible.

One trick I have used in the past is to create a small pop up form that informs tham that the data is being processed. It appears for a few seconds, then goes away. It doesnt do much but delay the execution of the code, which is neccessary for the proper information to be displayed. It does...

You could remove the primary key settings, then delete the field. Save/close the table, then reopen it. Add the field back in, and reset it to the primary key. This should work.

Have you tried a docmd.requery or docmd.refresh after the code that inputs the date?

You could create a batch file that would copy the files over for you, then call it from access in the chain of automated processes. Save the created PDFs in one file (c:\PDFS), then open NOTEPAD and enter the following. MOVE C:\PDFS\*.pdf H:\PDFS\ /Y The H:\PDFS\ would be the actual server...

Where I work we have a system based on GIS. We use it for scheduling routes for our field people. Since our actual database system is a bit unique, we have to export the data to Access, filter/manipulate it, then it gets imported into the GIS system. If neccessary, we can export it from GIS into...

For saftey measures, you may want to edit the MsgBox Error$ to MsgBox Error.Num This will cause the message box that appears to only show the erro number. Then in the code add an if statement to bypass just that particular error. Macro1_Err: If error.num = 1234 (number given in the message...

I would put the requery for the form in the close event of the other form. Form1 opens, the trigger form2 to open for data entry, when form2 closes its onclose function would trigger the form1 requery/refresh. The macro is probably functioning fine, just running the requery b4 the data is...

The command to turn the warnings off is DoCmd.setwarnings = false. Be sure to have this in the code BEFORE the command that triggers the warning.

Have you run the compact and repaire tool? I have found in the past when the autonum goes nuts, that usually take care of it.

If you wouldnt mind a slight change, you could make the combo into a listbox, then size it down to a single line. Say the list conatains names, and you have 250 in the list. You want to find John Doe, you could type J and it would jump straight to the Js in the list. I would sconserve space and...

Actually, when I develop anything, the developments and its costs are just a smaller portion of what has to be accomplished. There are many phases that have to be accounted for within a systems development plan. It would be nice if one could just jump right in and develop mdbs for companies and...

What about creating the tables in the version you have and save it as a previous version format. Then you can enter the data, and have it imported to the existing system, if this is an option.