Search results

Forget my last question Pierre!!! I figured it out!! Thank you so much!

thanks pierre, that works a lot better! the only thing that's not working now is that when I select the company that I want in the listbox, the corresponding records do not appear in the text boxes below it (it's set up like the example you sent). I can't figure out why but it seems like it's...

Hey Pierre - I have tried to recreate the database just so I know how to use it. I keep getting error messages from these two line: Dim db As DAO.Database Search2.Value = vSearchString What does the Search2 mean? I thought it was the name of a text box or something but can't seem to...

Hey Pierre - I'm looking at the sample database you gave me, and it's great, that's pretty much exactly (I think) what I want to do. I was just wondering - what version of Access does it use? I'm just going through it right now trying to get it to work on mine, and I've got a couple things...

Thanks, I will have a look at the sample db. Wendy

No, it's a Data Dictionary. Basically this is how it works: It's a database for storing information about all the files on a shared drive. A user can go and find out about certain files, but can't actually access them. I am the only one who edits any of this data on the system. It is set...

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...

Yes, you are correct [of the understanding]. I tried the first method and I end up with this in the filename textbox (on the form): #Name? I don't completely understand the second method. I pasted it into the query (under the file field) and I couldn't save the query.

Sam F - I'm not sure I understand it completely. Sent it as a parameter to this function? And where exactly do I paste that code? I'm a bit confused... sorry. thanks for the reply!!

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...

pardon? I have no idea what that mean.... Please explain.

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...

thank you!!! that worked. :) wendy

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.

thanks... that works.

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...

thanks. I used the application hyperlink and it worked perfectly.

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.