Search results for query: *

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--

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 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...

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 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...

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.

I have zero experience with ASP. In previous years I have had a html file to work with. I have an ASPX web page that I need to add a hyperlink to. I have a .gif image that I want to display and the viewer can click to access the hyperlink. I will be editing the aspx file from notepad. My...

I need to import a csv file into an Access database. The problem is the csv file has quotes on each side of the elements. For example: "Element1","Element2","Element3" I need to delete the quotes prior to the import. I want to do this with visual basic .net (Visual Studio 2013). Any help is...

I have an Access database that tracks services purchased by customers. I have a report that we use for billing that shows each customer with the details of the services purchased. The report totals the customer purchases. We use this report for billing. The report paginates by customer...

I need to update a field named BillMonth in a table named TW_Data with the contents of two comboboxes, combo4 and combo6. Combo4 contains two fields, the month name, ie January February... The second field contains the month number ie 01,02... Combo6 contains the 4 digit year. I need to...

We do business with a company that provides a service to many of our customers. I have an Access database that I use to import the .csv file I get from the service company. The .csv file has the details of each item and the company associated with the service. I have a report that prints the...

I am trying to use data in a textbox in a form to run a query. I have a simple database with one table, one form and one query. The table has two fields, name and date. The form has only one textbox. The query is attached to the table. I want to enter a date in the form and have it find the...

I am trying to create a new database. This database will contain phone call records I download from our long distance provider, TW Telecom. The file I get when I do the download is a .zip file. I attached that file to this message. When I try to import the data in the .txt file that is...

Hello, We have a Lucent G-3 V9.5 and we are trying to add a PRI circuit. I have set up the DS1, signal group and trunk group. Currently I have just 3 members in the trunk group, I will add the rest once it is working correctly. When I do status tru 8 it shows all 3 members “in-service idle.”...

I have a form that runs several queries in an embeded macro. It is set up as an event in the "On Click" selection. I would like to run the queries without having to answer all the questions associated with the query. Does anybody know how I can accomplish this? Thanks, Ron

I have a database that is used to create reports based on data we receive from a vendor. I have been working on using forms to make report selection easier for my employees. My vendor sends us an invoice for the service with notation regarding the dealer and the amount billed for each account...