Search results for query: *

Thank you, I found the problem in Sort. Your assistance is appreciated. Ron--

When I click Report View from report design I get a request for Expr1. I don't find this in any table or query. Any idea how to find and solve this problem? Ron--

Andrzejek Yes, I want to check a single field in a table to determine if any of the records are null. If so I want to run a query, if not I want to run a different query. Ron--

I have an Access database, I want to check a field in a table to see if it is null. If it is null I want to run a line of code: Do.Cmd.OpenQuery “QueryTitle”, acViewNormal If no null value is found I want to close the if statement and then run a different line of code: Do.Cmd.OpenTable...

Hello, I use an Access database to calculate fees that I need to charge my dealers for service provided by another company. We have dealers and dealers have accounts. We assign a dealer number to each of our dealers. We use a provider that provides a service to our dealers. The provider...

I want the secondary table to initially show me the records without DealerID's. We will add the correct DealerID and then use this table to update the main table with the correct DealerID. The AutomationID is actually the account number for the dealer account. All records have the...

I have a table that is my main table(titled Working). In addition to other fields I have a field titled AutomationID and another titled DealerID. I download this main table on a monthly basis. There are many records that do not have a DealerID. I have a secondary table that I want to use to...

I am struggling with a problem with an Access report. The code I am trying to use is currently in use in another Access database that is doing exactly the same thing. Over the years the older database has gone through many changes. I am attempting to create a new database that has less...

I have somewhat of an odd situation. I have a table titled working. In addition to many fields one contains a dealer ID. We want the dealer ID to be a number however sometimes a dealer enters their name instead of their dealer number. The service provider we use to manage this accepts...

Thank you. I didn't have the form opened when I ran the report. I made a couple of changes based on your questions and now it works. Ron--

I have an access database that has a from with a textbox (text2) that contains a date in the format yyyy-mm-dd. I need to add one month to this date and include it on a report. I have tried the following: =DateAdd("m",1,[Forms]![Prep]![Text2]) This dons not work. When I look st Report View...

I will try again to attach the file. Ron--http://files.engineering.com/getfile.aspx?folder=6614d490-2135-4774-9fd6-1dd51f21cde4&file=1705_I1061_DETAIL.csv

What you said made sense. I tried making the fields a number field. I tried double and long integer, neither worked. I have attached the file to this message so you can play with it and see if you can make it work. There are actually three fields that contain a 10 digit phone number. I only...

This is true, the filed is marked as text, that is what I want. I need to be able to make them look better like "(123) 456-4890". I still need to import the data. Marking them as text with quote marks works. I need to know how to run an excel macro or some other method to make the numbers...

I get a csv file from a provider that won't import correctly into an access table. Two of the columns contain a 10 digit phone number. When I try to import the file these two columns don't import. I have written an excel macro to add single quote marks to each side of the phone number making...

When I run this I get a dialog box titled Enter Parameter Value with netbilling.ItemNum. Ron--

I don't disagree. This simple code doesn't work. Do you see the error? Update BillCode SET BillCode.ItemNum = [netbilling].[ItemNum] where (select distinct netbilling.itemnum from netbilling);

I have a database with multiple tables. One table titled netbilling that contains (among others) the following fields: ItemNum ItemDesc SubsChgs I have another table titled billcode, I want to update the billcode table with data from the netbilling table. I want all of the fields above but I...

I am looking for a way to block an incoming call on a PRI TIE circuit based on the call's ANI.

Thank You This worked great!! Ron--