Search results

So I have split my database, and have a couple of front-ends accessing the back. The problem is that when one of the front-ends is opened it is creating a lock file, preventing it from being opened again. The front-end can still be accessed if I open access and open it from there, however, I...

Sorry wasn't clear the first time... wouldn't "=" mean the field has to only be cat? What can I put there so that the field on needs to contain the word cat? I know I have an example using macros and "like" but I can't get to it right now. Thanks

Thanks for the help Bob! Hate it and love it when the answer is so easy and just isn't coming to me on a Monday. DB data is being provided outside our control. Just need to find when our company is being mentioned in a field. Over 10k entries in the data, with only ~20 entries of relevance. Tis...

Wanting to make a filter that looks in multiples fields for a set word. For example a "cat" filter, where if the word cat appears in any of 6 designated fields, it would filter to those results. I have been using me.filter = "[field1] = 'cat'" filteron = true but I am unsure of how to...

So that gets the pop-up to load. However, now after I close the pop-up and try to move to a new record I get an error saying the record has changed, would I like to save, or copy the changes. I hit save, and it is not storing the data I entered in the pop-up. I am thinking my pop-up settings are...

So the structure essentially is view only form from tbl_data. Then a subform to set the characteristics of that entry referencing tbl_chars The characteristics are all yes/no except one, which is a memo. The memo is triggered if yes is answered as one of the chars. How I want it work is a...

Forms are being used for survey entry. Some fields are visible/invisible based on the input of other fields. For example, question 1b only turns visible if 1a is "3". My issue is actually with tabbing. Because I used LOSTFOCUS as my event, the tab already occurs before field is visible, even...

Ok that works awesome! Thank you so much for the help!

Ok, if you wouldn't mind helping, is this how it should be designed? The data that needs to be filled out should be designed as a sub-form. The original form would be based on whatever table contains the original PK. Thus when the user clicks from the client_center, it would load with the...

Hopefully this works. Kept getting an error when I tried to convert using the access converter. Pat, thanks for your help. That makes sense that you wouldn't want it to populate the FK before the user enters something. However, I am not really sure I understand what you are describing. Using...

My mistake, that line was from a previous experiment trying to get this to work. I am still getting the compile error on strEmplid of "If Len(strEmplID) > 0 Then" I've uploaded with appropriate forms/tables. Thanks

I am getting compile error, variable required, can't assign expression on the stremplid of If Len(strEmplID) > 0 Then. here is what I am opening the form with Private Sub Open_Client_Info_Click() DoCmd.OpenForm "frm_client_info", acNormal, , , , acFormAdd, [Empl_ID] End Sub and here is the...

Here is what I would like to do. I have a "client center" where you bring up the demo data on a client. On frm_cli_center, I have buttons to open 4 different forms. When a button is clicked, I would like it to open the form, carrying forward the empl_id of the current record on the client...

So I have a search function that work great. However, now if my search returns no results, I would like to have a pop-up that tells the user no results were found. (Ideally I would like to from the pop-up to ask them if they want to enter the user, but I don't think that is possible) Here is my...

That did not work either. I'm starting to think you just can't use the maximize command on a dialog report. Though I am not really sure how to accomplish the same goal through another route. Anyone have any thoughts?

I've tried a few, 10k, 5, 50k... It opens in dialog fine, then when the timer fires it gives me that broken report. I've put the maximize on the click event, focus, just about everything; all to no avail.

Harmankardon: I thought of this, but I can't see what else I would put it as that would maximize? acHidden, acIcon, & acWindowNormal all just open as a 'tab'. Thus when I use them, they do open even with the maximize command, but it isn't actually moving or maximizing anything, as it is just a...

Because it moves it to the 2nd monitor....

vba: Your 1,2,3 is how I originally had it. Got the broken report Putting maximize on the openreport command doesn't work, as when you open in acDialog, the next line of code does not run until the dialog box is closed Using a timer results in the same broken report image above.

Yes I realize the command moves it to the right. Everything is fine and dandy in that world. I've taken the maximize out, and the code runs fine. I'm thinking the issue is using the maximize docmd on an acDialog. Does anyone have experience with that working? I've put the maximize on...