Search results

From my immediate window, from your db: ? DCount("[Lab]","DevicesTbl", "Lab = 'Lab-A' AND device = 'LCD'") 3 Enter the above code in the control source of the relevant text box, image below: This should give you an idea how to configure your other counts. Also check out this link for...

No problems, I thought you would.

Do a Debug.print of your SQL variable and post here. Your screenshot does not show the entire creation of your SQL query. I haven't analysed it for syntax errors at this point in time.

From the link in post #4 So for the bare bones of it: "A "0000 I tested that umpteen times, admittedly I didn't get it right the first time but the answer was in the docs. BTW, that is a space directly after the "A".

I'm a new kid on the block, post-count wise, it will be a while before I get my name on the leader board, if ever. The problem with the leader board is that you'll be always looking over your shoulder but well done to all those 10k+ posters. ps. I've just added one to my post count.

Create a form, create two text boxes, name them accordingly (txtDateStart and txtDateEnd - or whatever naming convention you prefer). In your query criteria cell enter references to the form, similar to: Between [Forms]![frm_DateQuery]![txtDateStart] And [Forms]![frm_DateQuery]![txtDateEnd]...

Quick question, for your first query, how are the dates (from & to) retrieved or entered into your query? Edit: What June said as well.

Just another thought, from Form 2 simply reference Form 1 for your required ID value, this would be done in the On Load event of Form 2. (This assumes that Form 2 is always opened by Form 1)

There are a number of ways to tackle this scenario. First, have you considered a combobox in lieu of your textbox where users select the customer required? Might be an easier approach than directly typing a customer number into a text box. The rowsource of the combobox would be based on...

I can't test at the moment, but with 'data entry' mode on, you don't see existing records (not sure if you can navigate backwards to see existing records, as I said, can't check now). What this has highlighted though is that you were able to enter duplicate records, you may need to address that.

What the data looks like in the fields is not the issue, as long as the design is valid. Keep your users away from the tables, they should see the data via forms, where it's nicely presented. Users poking around in the tables, you invite problems, you don't want that.

Check if the second form you're opening is not 'data entry' only.

I was thinking the same thing. I couldn't find something I could play around with to test. I did find out that an unbound checkbox has three states, and is null on first opening. Once clicked though it's either true or false and the only way to get back to a null state is in code (unless...

Since everyone beat me to it, I'll just post a link to the inputmask and not include the rest.

Move your code to the AfterUpdate event. That means you can enter the textbox as many times as you like but if you don't make any changes the code will not be triggered. You may also want to read up on the BeforeUpdate event.

The images, as far as I can tell, do not indicate or show a command button on the right-hand side.

I can only speak generically as it's your database, you understand your business workflow, you know what the primary or main search fields are. Having said that, whatever the main search fields are, use them. Even use the barcode if it's something the users refer to regularly. Again, not...

Me.Recordset.FindFirst "[Name] = ""Raven"" " Apologies everyone if I side-tracked the issue somewhat. I misread the visuals AND didn't test it. Is there an emoji thingie for tail between legs and moving on?

Re: Referring a barcode string in Microsoft Access I'm not discounting the Soundex function and it has its use, but can we backtrack a little. If a user is requesting a file, ie the 'Jones' file, you will need to provide a search form/function, whereby the user types in 'Jones' or partial...

Just out of curiosity, and to recap so far: Post #1 Me.Recordset.FindFirst ("[Name] = ""Raven"" ") Post #3 Advised to change to the following Me.Recordset.FindFirst "[Name] = ""Raven"" " There is a slight error in the Post #3 syntax, it should be: Me.Recordset.FindFirst "[Name] = " & " "...