Search results

Most domain aggregate functions return a value if there is a match or NULL if there is not. DCount is the only one that also returns a value if there is no match. If you used DLookup, would have to test if return is NULL, like: If IsNull(DLookup(...)) Then I NEVER allow empty string in table...

Parenthesis must be in pairs - that means an even number. You have nine parens - none of them are actually needed in that clause. Access throws them in with query designer but you can delete them in the VBA construct. GROUP BY clause must be after WHERE clause. Doesn't make sense to me to...

With VBA, options for passing data between forms are OpenArgs, global variable, TempVar (macro can also refer to TempVar), one form refers to control on another form (as you already do).

First SELECT in UNION defines field names. The AS aliases in the second SELECT are not needed and won't even show. In other words can do just: PaidTimeAnnualLeave, Null, Null, Null

Actually, might not cost so much to mail international. If you want it, let me know. You wouldn't have to pay me. Discovered I actually have 4 of varying lengths and cable thickness, even one that branches.

I have 3 of these of longer length that I have no use for (don't even remember how I acquired them):D. If you're in the USA I could mail you one.

I think converting to wireless is a no go. I have seen wireless hubs that gamers use to connect wired mice/keyboards/joysticks. Could get a male to female coupler or short cable. Plug in your bad end and wrap some electrical tape around it to stabilize then plug in new good end to computer...

Cross post https://www.utteraccess.com/topics/2066625/posts/2828938

Are you sure records in subform are deleted or just no longer displayed? Have you set a relationship in Relationships and enforced referential integrity? Why set focus to subform when opening if not opening to an existing customer? Post code that is opening form or provide db for analysis.

Not my philosophy. I make forms do double duty whenever possible. I may have edited my previous post after you read it.

Right, OpenForm and its WHERE criteria cannot be applied to filter a subform as subforms are not a "form" in the Forms collection. You can apply criteria to subform Filter property (which I think can be done with macro or VBA) or use some "go to record" method. A common approach uses Bookmarks...

Use VBA instead of macro and debugging will be easier (I never use macros). You have a modal form with a macro that is opening another form and that form has subform you want to filter? Conventional approach is to filter main form and subform master/child links synchronize subform. As...

I am thinking normalized is like: IDlone nojointwelderdata 1swf111 2swf122 3swf131 4swf141 5swf212 6swf223 7swf232 8swf242 9swf314 10swf325 11swf334 12swf344 13swf416 14swf424 15swf436 16swf446 17swf513 18swf522 19swf533 20swf543

This data is in table in Access? You provide 5 rows of sample data but say "4 rows" in statement. You want to know how many distinct numbers are in all 5 records combined - which in this case is 6 numbers - all from the WelderX columns? Your options are a VBA procedure or a sequence of...

What is Context and why is not concatenated? Domain aggregates can cause slow performance in query and on form if large dataset is involved. Want to provide db for analysis?

You are building a string - a string that is an SQL statement. I think that's what Doc was getting at. Need to concatenate VBA variables, you had sTable embedded. Embedded TempVars will work because Access SQL can evaluate TempVars.

Automating either approach will require VBA. In either option presented, code will "batch" create a set of records, whether retained permanently or not. This is actually a fairly common topic but you are a long way from being able to accomplish. Otherwise, manual data entry of individual...

I can set a link to Outlook Inbox folder and see the connection string. I used that in query with [Inbox] as [subfolder] and query works. Your reference doc doesn't show Attachment is used by MAPI, so guessing that won't work in connection string. Maybe this is not possible with SQL. As I...

Something like: SELECT table.* FROM table INNER JOIN reference_table ON table.city = reference_table.city or SELECT * FROM table WHERE city in (SELECT city FROM reference_table)

Please edit your post to place code between CODE tags. This will retain formatting and make it easier to read. Click the </> button on post edit toolbar. Or you can provide db file for analysis. Follow instructions at bottom of my post. Explain issue with code - error message, wrong result...