Search results for query: *

Hi Everyone, All I want to do is insert the current date into an existing record when a form opens. I use: Me![txtOrderDate] = FormatDateTime(Date, vbShortDate) with form event On Activate. Since the record already exists, the Default property doesn't work. I have tried events On Open, Got...

Hello, Can someone suggest a way to duplicate a record in a recordset? I was going to do this in a query with a Cartesian product, but I need to be able to conditionally duplicate some records and not duplicate others, before exporting the recordset as a text file. So what I'm looking for is a...

Hi, Can anyone suggest the code to carry forward values on existing records? DefaultValue works only on new records, my problem is opening existing records to add more information, then carrying the values of some controls to the next record while that form is open. Thanks! -Tom

Hello, I need to create a form (based on a query) so that the user can select certain records and then those records are exported as a CSV file. The CSV must start with a number that represents the number of records in the file, followed by 10 blank lines, then the actual records. And, a blank...

Hi, I'm converting a tables and need to change dates to plain text strings: 6/4/2002 to 060402 11/9/2000 to 110900 Anyone can help on the code I'd appreciate it!! Thanks, Tom

Hi, I have an Orders table with a field that contains product numbers. The product numbers are the real product numbers, not the Product_ID (autonumber) from the Products table. This was a mistake because I need to change product numbers in the Products table and they won't be updated in the...

Hi, I need to select records and then export them as a csv file. The trick is that I need to duplicate each record before exporting: I figured on using a query to select the records, but how do dulicate them so that they will look like this in the csv fle? ID1, Smith ID1, Smith ID2, Jones ID2...

Hi, I'm working on someone else's database and trying not to change the tables, but they are not normalized and I need to regularly import .csv files. I can use an append query to add the newly imported records into a temp table, but I need to copy the values from the the temp table into the...

Hi, I'm working on someone else's database and trying not to change the tables, but they are not normalized and I need to regularly import .csv files. I can use an append query to add the new records into a temp table, but I need to copy the values from the the temp table into the the correct...

Hi, I am getting two different results between a parameter query and a filtered query. I have a Main form/Subform. The subform Data Entry=Yes. Using the parameter query as the record source when I open the form, only those records that meet the criteria are show in the Main form and the subform...

Hello, My problem is how to refer to a control on a subform in the following situation: I have mainform/subform, with a combo box on the subform. If you enter a name in the combo and it isn't present, then a new account form opens, the name you typed is entered into a new account record, then...

Hi, I want to put a combo box on a main form that will restrict the products that are available for ordering on a subform. Using the Northwind example, the Order form would have a Suppliers combo box so that when you move to the Order Details subform to choose products for the new order, only...

Hi, I'm using Northwind.mdb as the basis for creating a simple supply order. I want to restrict the products that are available to order in the order subform based on a particular supplier in the main form. Ideally, I also want to restict based on the product category. "Mastering Access...

Hi, I'm using Northwind.mdb as the basis for creating a simple supply order. I want to restrict the products that are available to order in the order subform based on a particular supplier in the main form. Ideally, I also want to restict based on the product category. "Mastering Access...