Search results

Hi all … I’m working on a customer billing system and this one has me stumped. I need to figure out the average amount of each customer’s last two bills. On the surface, this seemed like an easy query; but I’ve run into problems because not all customers have charges each month. The table...

Within Access, I'm using the code shown below to create a link to a SQL Server table. My code works; but I need to make the linked table updatable. If I create the link manually, Access prompts me to choose the "Unique Record Identifier" field(s); but I can't figure out how to provide this...

I'm importing a number of text file into an access table and I've got a problem with inconsistant data formats within a phone number field. Below are a few examples of the data I'm trying to clean up. (xxx) xxx-xxxx xxx-xxx-xxxx xxx xxx-xxxx What I need is some VBA code that will find and...

Hi All, Does anyone know of an easy way to specify a range of values for a combo-box without creating a separate table or actually typing each value in the value list. In my case, I need the numbers 0 thru 60 ... one combo-box has the numbers in ascending order, and another has them...

Hello, I'm a hopeless newbee when it comes to writing VBA code; so I could really use your help. All I want to do is write code to read in the results from an existing query. For the sake of example, my query is named "my-Qry" Below is the code I've written; but when I try to run it, I get a...

I've got a form with a combo box that I'm using to pass criteria to a query. Everything works great if I want to find records for a fixed condtion (e.g. = <> > < etc.) My problem is that I need to be able to pass both the conditional expression and criterial value to my query. Sometimes I...