Search results for query: *

Is there a way for Access to recognize values which are case sensitive. For example, I have a table imported via ODBC from our main computer system which has the following records: Terms Code Discount H 2% h 1% When trying to update a second table which has...

I have 2 tables as follows: 1. Production Table 2. Mold ID Table I am trying to populate the following fields through a data entry form bound to the Production Table with information stored in the Mold information table Part Number, Mold ID, Cycle Time The mold information table...

I have used a setting in the registry before which allowed me to increase the database size. It was given to me by microsoft. I am sure there is one available

Is there a command in the Regedit that I can change to prevent this from happening. I get the same problem even after I have repaired and compacted the database. Thank you Mike

I have a data table with a "part number" field populated as follows: Part Number 101 101* 101c 107bc 107bc* 107c The asterisk at the end of a part designates that the part is a retail part. For example, a 101* is the same base part as a 101 (a 101c is a completely different part)...

I have a query which counts the number of workdays between 2 dates. Is there a way to exclude holidays in the query? Mike

I am running an update query to populate empty fields in a table. The "update to" criteria is a calculation relying on the prevously calculated field value in the update query. I am having to run the query several times (once per each update calculation). Is there a reason for this...

I have a table with 4 fields which get updated via an update query. All of the updates are accomplished through expressions releying on the previous calculated field value. I have to run the update query 4 times in order to fully populate these fields. Any suggestions on how to get all of the...

I have a make table query in Access which, when running, prompts me to "enter parameter value" for a calculated field in the query. It then propmts me again for a parameter value for another calculated field which uses the first calculated field in its calculation. By hitting ok (and...

I have a simple data entry for that I am using to enter records in a table. Many of the fields are repetitive from the previous record. Is there a way to have the default value for the new record default in the form to the value of the previous record. Thank You Mike

I am not clear on the code to use to get the value of the "previous" record to come up in data entry for a new record. I looked at your advise and am still unclear. Thank you and I look forward to your response.

I have a data entry form and am trying to reduce the number of keystrokes to enter new records. Since alot of the fields are repetitive from the previos record, how can I, when entering a new record, have the value of the previous record display in the field Thank You

Thank you for your quick response. But could you please give me some specifics on how to use the "like" command or a module/procedure process which could help. Thanks Mike

I have to data tables. One data table has a field called part_no with the contents of the field looking like this Part_NO Cycle_Time 101,101BC,212 55 The other table also has the field part_no with the field populated as follows: Part_No 101 101BC 212 I need to populate the...