Search results for query: *

I have a table that lists reports I have a form that has comboboxes that are used as criteria for the queries underlying the reports I have added the table of reports as a sub-form to my criteria form. I have a button on the form. I would like to select a record from the subform table that...

I have a set of data where certain fields contain an *. I want to find and remove these asterisks. I have the same problem with the # sign. Since these characters already have a meaning in Access, they are not being treated as simple strings. How do I force Access to treat them as text...

I have a table where I import data. This table has several fields. I need to exclude certain records from my report based on a value in a field or a combination field values. Users need to add/edit these values so I have created a form for them to input records where if they need to exclude...

I have an .csv file and am trying to import it into my Access DB. Nothing fancy just a simple import in VB. I can import manually using same spec into same table with no error but when I use the code I get the runtime error. Pls help this is driving me crazy. my code: Sub New_Vol_Import() Dim...

I have a table called Data. This table has fields labelled Client, ChargeCode, PeriodYear adn PeriodMonth. In another table called AdjChargeCodes the following fields exist: ClientCode, FromChargeCode, ToChargeCode, PeriodYear and PeriodMonth. I need to run a procedure that will open the Data...

I have 2 tables, agg and agg2. Agg has charge lines where the income and expense are the same but under differenct codes, for example: container Charge Income Expense Difference 123 CMF 20.00 -20.00 0 124 ADD 15.00 0 15.00 124 ADM 0 -15.00 -15.00...

I have 3 tables. A container table. Each container has one or more cargolines stored in a cargoline table. Each cargoline has one or more invoice lines with one or more charge codes stored in an invoiceline table. container table containerID, Arrival Date, Vessel, measurement 111...

I have a document template that uses form fields. Some of the fields are required so I need to use the 'BeforeSave' event to open a msgbox advising user to fill in the fields, then do not save the document and exit sub. I have the following code: Private Sub appWord_DocumentBeforeSave(ByVal...

I have a table w/ field 'Invoice_Number'. The type is 'text'. I am importing a text file in which this field contains both letters and numbers as values and some are just numbers. Why am I getting a type conversion failure, shouldn't access simply treat the numbers as text?

I have a query 'Subimport_Value' which is a query based on the tmpimport table wich is group on for all fields except 'value' which is summed. I have another query 'update_subimport_value which is based on the 'subimport_value' query and is an update query which updates the 'value' field of the...

I have a db that uses a Import Specification to import a .txt file. Recently the .txt file's field separator and format has been changing from month to month. Is there a way to make a user-friendly interface for the user to edit and update the import spec?

I have a table with about 600K records in it. When I open the table, it takes a long time and the query status bar shows up at the bottom of the screen as if I were running an action query. Why is this happening and what can I do to make it faster. I am running Access 2003 and I have...

I have a database that exports an invoice to excel and opens the file. Then I have an Excel file which holds the macro I need to run on the innvoice file. I can get both files open, but once I activate the invoice in order to run the macro, the code can't find the macro anymore - it only works...

I have a block of code that imports data from an xls file. Opens the recordset and does some field updates and calculations. I think the If statements within my loop are really slowing down the processing. Pls take a look and advise how I can make this code more efficient. Thanks [code] Sub...

I keep getting a runtime error saying 'Syntax Error missing operator in query expression' but I can't see where I am missing something? I need to get two values from a subform that is open at runtime. This sql works fine in the query panel. [code] UndoImport = "SELECT PRMFinancials.FileCode...

My code starts by creating a file called ICB_All.xls Then I need to look in the directory where this file was created and import the data from all other files within the directory into ICB_ALL.XLS. So the order of things: 1) create File1, File2, File3 in C:\My documents 2) Create ICB_All.xls in...

I have code that filters a column, then adds values to the visible cells of an adjacent column. The code determines the row number of the first visible cell excluding the column label. It uses this row number in the formula it pastes into that cell. Copies the cell. It uses the filtered...

I have a table. The first column called 'Category' is blank, I need to filter by 'BusinessType' column then fill in 'category' column based on various criteria (values in other columns). My code partly works but these are my problems: 1. The label 'category' is changed along with the other...

I have a table. The first column called 'Category' is blank, I need to filter by 'BusinessType' column then fill in 'category' column based on various criteria (values in other columns). My code partly works but these are my problems: 1. The label 'category' is changed along with the other...

I need to determine if a value of a field is null in a Case statement - I can't figure out the correct syntax Here is my code: Select Case rs!reference_no Case "FILES REMAINING OPEN FROM THE PERIOD" rs.Delete Case Is = Null rs.Delete End Select Please advise Thanks