Recent content by ebodin

For a different approach which is easier and works well in the right situation: I put my FE on the network and users access it through a shortcut that I send to them. When I update the FE I give it the same name as the old one so that their shortcut is still valid. There is also a link from...

It works! I could have sworn that I tried that. Apparently my compiler doesn't believe me, it only believes you. Thanks Vassago. I'll be back.

I'm trying to make this Dcount work I've searched the forum and pondered other examples. I don't think I need any quotes since the criteria is a number. I've verified that the int3 is what I want it to be immediately before the Dcount, but the result of the function is as if I haven't put in...

got it I got it with this code I found on another post. Don't know why the extra quotes didn't give it to me. Dim MyFileShell As String MyFileShell = ""C:\Documents and Settings\Desktop\Book2.xls"" MyFileShell = Chr$(34) & "C:\Program Files\Microsoft Office\OFFICE11\excel.exe " &...

I want to be able to launch a certain excel file from a button in Access. I've searched the forum and have found that there are problems passing filepaths with spaces in them. The solution is using more quotes around the filepath to pass the spaces too. However, I'm still having trouble. Can you...

I suppose that it has worked for me to split the DB, but provide shortcuts on desktops to the FE that the user needs (instead of installing the FE on the user's desktops) because the FE's that I supply in this way are read only, and because I don't have a large number of users at one time. Data...

What is your environment like? How many users do you have? Is your DB read only? I have a read only DB (to the end users) that is available to everyone in the factory (on the Intranet), but only used by a handful of people per day. We have a link from our webpage that launches the application...

I'm aware of the split database idea. I have implemented this. However, instead of installing FE's on everyone's computer. I distribute a shortcut to the front end. When they open the shortcut, it downloads the front end to their computer (I think) and then allows the user to search the DB...

I have a DB that I just distribute a shortcut to a front end on a network location. Then when I update the front end I delete the old one and give the new one the same name as the old one, so everyone's shortcut still works, but the FE has changed. I haven't seen anyone else do this, which...

You mean like this? Private Sub cmd_OpenShopFloorAccess_Click() On Error GoTo Err_cmd_OpenShopFloorAccess_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "sfrm_AllChemShopFloorQry" If DCount("[e-MSDS]", "qry_AllChemShopFloor") > 0 Then DoCmd.OpenForm...

I didn't mention that the query runs from a command button and the query asks for user input. How/where would I include the If statement in this code? Private Sub cmd_OpenShopFloorAccess_Click() On Error GoTo Err_cmd_OpenShopFloorAccess_Click Dim stDocName As String Dim...

I have a query that displays results in a form, but if the query is null, I want to display a different form, or just an error message that says something like "your query returned no results" (right now it will display the form with no fields) I am a beginning Access/VBA user and have searched...

Thanks! That wasn't in the Help files.

I have two fields (Vendor and Manufacturer) -which to a user searching the DB seem very similiar- and I want the user to be able to search and return results that appear in either field with only one input, but still maintain seperate fields. I've tried prompting the user with: Like "*" &...

I've been using the ctrl+F search in order to search my db for a string or phrase (from a form). Now, after I put it on the Intranet and accesss it through there, I use ctrl+F and if I search for something that is not there, it doesn't return a "did not find" box. It's like it just keeps...