Search results for query: *

I have a problem an would like to see if anyone can help me get this to work. I have spent a great deal of time already trying. Here is the problem. I need to copy a template file to the proper directory and rename it so I can append the worksheets to thae name selected. Here is my code...

I am having trouble referencing a list box value in a sql stsement it tells me my syntax in incorrect. Can anyone help? DoCmd.RunSQL "UPDATE MainParts SET MainParts.ResourceName = (Forms!Parts.[List34].Column(0))WHERE((Forms!Parts.[Text20].Value=(MainParts.PartNum)))" Jimbo[bigsmile]

I have coded DAO to perform this operation to a local .MDB but ADO connection strings and working in the recordset have me stumped could anyone please point me in the right direction I have spent a few hours tryin all I could find on the subject of connecting and the like. Here is the last code...

I have tried the path %currentuser%\Application Data\Microsoft\templates this did not work. Is there a way to get to the current users profile and load the template into their templates folder automatically? I have to distribute this file to a nationwide group of users and I would like to...

Access 2000 .ADP and SQL Server 2000 Hello All, I have created a table that allows users to input data fom a form and update the TOTAL_RESOURCES_ASSIGNED column. When a user modifies this value on this row I need the current date time inserted in a field for time-Stamping. SEQ int 4 0...

I have an unbound form (Microsoft Access 2000 ADP/SQL Server 2000) which has a list box containing values from a Views'Single field (only 1 field for Flagging). When the value is Y, I intend to turn OFF an overlayed image on the form. The value in the local window is always "null" no...

I have an unbound form (Microsoft Access 2000 ADP/SQL Server 2000) which has a list box containing values from a Views'Single field (only 1 field for Flagging). When the value is Y, I intend to turn OFF an overlayed image on the form. The value in the local window is always "null" no...

I have an unbound form and I have seven queries that count the number of records. I need to display totals for each "Open Picks per Wave" in the form. I want to have each result displayed in a text box. I will set up a button to requery and update the linked table for updates...

I have a form that takes input from many fields and modifies the underlying query. I have this code for selecting a criteria based on a check box value. This statement brings back a "Type mismatch" all fields are text ... If (Me![ChkNODY]) = True And (Me![ChkNODN]) = True And...

I have a form that takes input from many fields and modifies the underlying query. I have this code for selecting a criteria based on a check box value. This statement brings back a "Type mismatch" all fields are text ... If (Me![ChkNODY]) = True And (Me![ChkNODN]) = True And...

I have my query set up and all works fine excepy I want to set up the three check boxes at the end of the code to include all the values I get no results from the query when I check more than one. Do I need to requery after each checkbox? I am not sure how to go about this. below is the code...

I have a table with date field(-Date Range-), warehouse, part number field, reason code field, Catalog Number, Dollar ammount field. I want to use a form to Pass any Entered Input for the multiple criteria in a query from a single form. Example ..If the user wants to have all records with...

I have an unbound form which references multiple criteria n a query. The problem is when I do not enter any of the date criteria("between" Style) and enter information in any of the other criteria the query brings back 0 records. I tried to put in an "or" statement to specify...

I have an unbound form which references multiple criteria n a query. The problem is when i do not enter any of the date criteria("between" Style) and enter information in any of the other criteria the query brings back 0 records. I tried to put in an "or" statement to specify...

Access 2000-I need help coding to select the current record on my form and copying it to another access 2000 database. I have looked at paste append( only takes it to the current table) and an append query(Which I can send Queried records to another .MDB But not necessarily the current record )...