Search results

Ok...looks like I had an error in my simple append query. That is up and working now. However, the process still appears to be a bit slow. It took approximately 7 minutes to append 170000 records to the SQL table. Does this seem correct?

All, I recently moved from having my database within Access to now having it within SQL. Basically, my access application will remain as the front end and SQL Server will now be the back end. After getting everything set up I tried to add some data with the access front end. It works fine...

So could you help me out with the steps on how to do this? Where do I download the development extensions to build this? Thanks...

I am currently working on an application for a friend. I am developing this application in 2003. However, they are running 2010. So far we have tried just sending my application directly over and running in 2010, but when information is being read into the database issues begin to appear...

CEH...thanks for the info. This helped to clear things up for me. Things are working well now. Also, I used the option group wizard to set the default settings.

I am trying to use the Option Button on a form. I have never used this before and I am experiencing some trouble. I have two options, one is to be used to "export only new records" and the other is to "re-export". The default setting for the when the form is first opened should have "export...

Thanks...looks like I was missing the first part.

I have the following code in a .bat file: Somedatabase.mdb /x TestMacro The database will open, but the macro "TestMacro" will not start. After the database is open, I can can manually click the macro and it will display a msgbox as it is intended to do. Any idea why this is not working?

Ok, things are working well with this approach. My next issue is that I need to take the query and split it back out into separate columns so that it can be exported as a text file. Right nows I have the following for a given query 'Data Select Query': ..., Channel Name, Channel Value, ...

Ok...after a bit more thought, and consulting with some others...I have moved all of the 'Channel A' , 'Channel B' , ... into one column called 'Channel'. So instead of having 15 channels across, I now just have one channel which will change with each record that is entered. I think this will...

Thanks for the information. I read through a Microsoft Support article on normalization. To be honest, however, I think that the approach I am taking adheres to the 3 levels of normal form...although I probably need to digest this a bit more. The reason I am including the 'Channel A_ID'...

All, This could be another simple question...here we go: 'Channel_Data_Table' contains 2 variable channels each with their corresponding channel ID column. Channel_Data_Table: Channel A, Channel A_ID, Channel B, Channel B_ID 'Conversion Table' is used to store channel ID's and their...

Ok...sorry about that. While I was posting this, I also added an SQL ROUND statement that formats the data two decimal places. So the Cash field is actually just $4,474.57 I am now getting the correct answer. Thanks for your help. The plan I had was going to get messy really quick, but...

I just gave that a shot. For one of the records, the cash is "$4,474.5703". The result after using "Format(rs![Cash], "00000000.00")" is as follows: "000004474.57". Not exactly what I am looking for. Does this make any sense?

I am printing values from a table to a text file. When printing the column for price, regardless of the actual price in the table, I need to make sure it fits into 10 digits which will then be printed to a text file. For example: The price in the table is $1.45. When I print to the...

Ok. Thanks for the information. I went through the link attached and tried out the following code: Set db = CurrentDb Dim rs As DAO.Recordset Set rs = db.OpenRecordset("Some_Table", dbOpenTable) Do While Not rs.EOF Print #FF, DLookup("[Column1]"...

I am currently using the following statement from within Access VBA to print records to a file: Print #FF, DLookup("[Column1]", "Some Table") This part has worked. For the next step I would like to print the next records in the table, starting with the first record and ending with the last...

The other thing I forgot to mention is that when creating the A and B records I need to reference another table in order to appropriately create the values for the A and B records. The original C record contains some unique "tracking number" that will correlate with the tracking number in the...

Essentially records containing 'C' need to be "decomposed" into a record containing 'A' and record containing 'B'. Records containing 'C' do not fit into the next step of the process. They need to contain information oriented in the same way as 'A' and 'B'. Hence the reason I am first...

namliam... ok, so help me out here? Why is this a bad approach? Here is part of what I need to do: I will be importing a text file into a table. The table will contain a field with values that are either A,B,C (once again, keeping it simple). If the field is C, I need to create two...