Search results

Hi, I have a main form where I (the administrator) update records fairly frequently. I may be constantly going back to the same records over and over again. So, what I would like to do, is have a button on the main form, which opens up a subform where I can do a search on the filename, and...

Hi - I have two fields in my records. Filename and FilePathname Both of them display the filename; One displays the full pathname and the filename. The other one displays just the filename. Example: FilePathname: c:\temp\mydocuments\test.doc Filename: test.doc To select the...

Hello, I have got the following code on a button which sends an email inserting the current record into the body of the email. It works fine, however, I would like it to insert ALL the records from the form (there may be multiple records) instead of just the current one on the screen. I would...

i have created a sample database and in the tools ---> startup, I unchecked the following: Allow full menus Allow Default Shortcut Menus Allow Built-in Toolbars Allow Toolbar/Menu Changes Use Access Special Keys How do I undo this ??? I'd like to know how to go back. Thanks.

Hi, I have set up a browse folder button so that the folder you select shows up in the textbox. However, right now it displays the pathname as this: M:\Shared\foldername When I want it to show up as this: \\Zeus\SharedData\GIS\Shared\foldername This is the module code for the browse folder...

Hi, I have a few forms that contain a command print button. It works fine except for one thing. It seems that when it prints a report, the whole database seems to shut down. This is the code I have in my on_click command print button: DoCmd.OpenReport "rpt_frmDept", acViewNormal, ...

I have got a text box which displays the pathname and the file name txtLocated. There is a browse button beside the text box where you can select the file you want to be displayed in txtLocated. However, I have another text box [txtFile] where I would like to JUST display the name of the file...

Does anyone know how to make a command button on a form open up another MS Access database. I know this is so easy but I can't figure out how to do it.

I have created a command button that lets the user browse to a file on a drive, and then the entire pathname and file name is displayed in the text box [Located] next to it. Everything works perfectly, except after the closing the browse to dialog box, there is an error/debug window. I can...

Hi, I have two text boxes: txtFile and txtDatepost In the textbox txtFile, the user browses to find a file in a drive. The selected file and path name is then displayed in the txtFile. In txtDatepost I have put into the control source: =Filedatetime [txtFile] which works fine...

Hi, I have set up a little program where you can browse to a specific file and the file and pathname are displayed in the textbox "txtFile". I then would like a textbox where the "date modified" of that particular file (from Windows Explorer) is displayed by clicking on a button called...

Is there a way to select multiple files and have them copy to another location?

I have created a data dictionary where I want to be the sole editer of the data (and all the users just view it), but when a user updates the main "shared" drive (that all the information the data dictionary is based on), I receive a trigger telling me that a file has been replaced and I need to...

Hi, I have created fields on a form. Recently when I have started entering data in them, if I press enter, I go to the next field. I do not want to do this. I want to press tab and go to the next field (which does happen) and when I press enter I want to start a new paragraph. Does...

Does anyone have any experience with Access databases and linking to them the metadata tab in arc catalog? I have just created a data dictionary in Microsoft access and was wondering how difficult it is to link the data entry fields in my database to the entry fields in the arccatalog's...

Hello, I am creating a database to view information. I have a query called qryAll. I have a form called frmDept. On this form I have two cascading combo boxes. The second selection depends on the first. In the row source for the second combo box I have the following code: SELECT File...

printing a report from a form Hello, I have set up a report to print right from a form. It prints whatever records are displayed on the form. I thought it was working perfectly, until I realized that it was printing the same report over 11 times! When you view it in print preview, there...

i have managed to reference the text box just fine [from a form to a report]. However, I have a form called: "frmDept" In this form, there are two cascading combo boxes, with 6 fields beneath them. The form is based on a table called: "Layers" Layers has a number of lookup columns in it...

I have created a form where the user selects two combo boxes, and the resulting records show up in the fields below. I want to create a report that reads off this form LIVE including what was selected from the combo boxes. Also, I have not used any queries for this, and I would prefer not to...

I think this may be quite easy but I have a form that is based on a search result. I want the user to be able to hit a button to print the form with the fields (and what's in the combo boxes) that he/she has selected. It seems easy enough to make a form, but how to make a form based on the...