Search results

It sounds like the dataabse is either badly normalized, or that the previous programmer took little or no advantage of what relational Databases can do. I would like to see a set of these Queries. The database should have at least the following Tables tblContacts: ContactID (PK) (Other...

I see a few issues here. You have a some basic Naming Convention issues, and you have a structural issue with the Query. Naming Convention issues: Table, Field, Report, and Form Names should not include any special characters including, but not limited to !@#$%^&*()?\|. They also should not...

I totally agree with plog here, and to expand on what he is saying, It has been my experience that not only does a DLookup not return results as fast as a Joined Table Link, but as the amount of Data being processed gets larger, the length of time for the DLookup gets longer as well. -- Rookie

You should be using VBA to do this, but the following (untested) Replace() Function Calls added to your Queries could be a good start for you: Query_Numeric CLng(Replace(Replace(Replace(Replace(Cstr(Credit_Card_No), "0", "2"), "7", "9"), "4", "6"), "1", "3")) Query_Alpha...

Have you looked at DSum()? It is a companion Function to DLookup(), and might be what you are looking for. -- Rookie

The Standard configuration for an IF() Statement should get you close to what you want. IF([Logical Test], [Value if True], [Value if False]) Your [Logical Test] would be [Quantity <= 1000] Your [Value if True] would be Price A Your [Value if False] would be Price B Of course, you will...

Unless you made a Type-O, there looks like there is an extra space in your last LIKE Statement that could create an invalid match (See above in RED). Maybe changing that will make a difference.

I am looking to get involved with Access User groups in the USA. I am aware of an Access User Group in New England that Pat Hartman is/was involved in, but was hoping to find something in the NJ or Eastern PA area. Going to meetings online is great, but I am still old fashioned enough to think...

Re: How? Concatenate fields if Null/0 OR concatenate "these" fields instead if NOT nu Always glad to know that I can help out

Re: How? Concatenate fields if Null/0 OR concatenate "these" fields instead if NOT nu In the version of Access that I have, a Comma is the Proper separator for IIf() Statements. so try substituting Commas for the Semi-Colons and see what happens. -- Rookie

What was the final syntax for your SQL Code? I noticed some things (See Below) you should look at: Your definition and usage of your variables needs to be checked. Adding a line containing OPTION Explicit at the top of your Code Module will help with this Your Where Statements are not...

them all to

MikeLeBen's approach to creating and then updating the record valid, although what you want should be able to be accomplished using Domain Aggregate Functions. I should state up front that I am not the greatest fan of Domain Aggregate Functions, since they can slow down some processing, but...

made the girls

delight of Sir

of unhappy children

The SQL Code below (taken from the posted VBA Code) should not be in the in the VBA Module, and instead needs to be in the Row Source Property of the cboClubs_Inschrijven Combo Box. Open up the Form in Design Mode, select the Combo Box Property Sheet, and update the Row Source Property to...

A Table that needs 170 Fields would be extremely unusual. It sounds like it may be the layout for a Spreadsheet, but without any more information, it is difficult to assist you further. If you could provide a Table Layout, or a stripped down version of the Database with a few records of test...

A LEFT JOIN from the Access Table to the Server Table that seeks any records with ther Server values that are NULL should give you a list of the New Access Records as long as: The Access Table has New Records that the Server Table does not The Server Table has no records that the Access Table...

that he found