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

Thanks, the brackets did it.

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 got it to work with this code but seems a little clumsy. Pls advise if you have a better way. Option Compare Database Sub Filter_CustomerDrayage() Dim db As Database Dim rstFilterCustomerDrayage As Recordset Dim rstFilterListCustomerDrayage As Recordset Dim intI As Integer...

How do I make it so the user does not have to change code if I am typing strings? Please explain how to set this up? Thanks

I do not want to 'hard code' any values as users will be adding/editing and deleting 'situations' in which we need to exclude records. This is why I wanted to use VB and have it look at a table?

I have a field in the filters table that matches the field in the data table. For example the fields are: Facility Point1 Point2 Dispatch Office I need to exclude records where facility = CHI and point1 equals 'BNSF'. So there is a record in the filters table where Facility = CHI and point1 =...

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

Perfect, thanks.

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

Thanks for quick reply. I chose to try: select dbo.tcontainer.snumber from dbo.tcontainer where dbo.tcontainer.liD not in ( select dbo.tcontainer.liD from dbo.d_cargo_line inner join dbo.invoice_line on dbo.d_cargo_line.cargo_line_ID = dbo.d_invoice_line.cargo_line_ID where...

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

Thanks! This works great! 3 stars for you.

What event would evoke this code? The checking needs to be done at the time the user is trying to save a copy of the template.

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?

Where can I learn about this table and it's fields and values? I have searched 'MSysIMEXSpecs' in google and not much results.

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