Search results

I must not have been clear enough. I did read that, and did not get the information I needed. Let me try to put it in words to my current problem. I have a table with over 2.5 million records. Trying to run any type of query on it takes hours(days in some cases) I have found that I can put...

I have a question. I know if you have a static size string of say 30, the string is going to be 30 characters long no matter what is in it. But if you do not declare it to be static does it just use some sort of maximum size, or does it change as it needs the space? For example if you have...

I tried it, and it did not work. It gave me a -3807 error saying that the table does not exist. But I double checked the spelling, and it does exist. Could that be a general type error, if the server does not allow pass-through?

would you be able to tell me how that can be done? Also do you know if this would cause problems on the server? It is a production server and to bring it down could have adverse affects on my current employment status.

my table is indexed. The problem was that the table is running on a sequel server<sp> I think I was able to get it working. I imported the table to my access, and it has been running my query for an hour and a half now. Unfortunately, because I am at work, getting software is very tough...

one thing you may be able to try is to open the access.exe without a database, then go to file and select the db you were just working on. It should put you into a design view. I don't know if it will work or not, but it is worth a try. That is how I got to one of my db's when access screwed...

everytime I try this access crashes. I have a suspion that the number of records that I have could cause a problem. there are about 2.5 million records in my table. When I use the duplicate query wizard, it just times out.

I have a table that has country_code, Mfr_num, Item_num, catalog_code, mfr_obsolete_code. the key is on country_code, mfr_num, and item_num. I need to find duplicates of mfr_num and catalog_code. Can anyone point me in the right direction on this?

SQL = "INSERT INTO tblContainers (Container) " _ "VALUES ('" & [Container] & "')" In your example you do not have the second & after container. If this is not a typo, then that is your problem.

your can try using something like strSQL = "insert into tblData " & _ "(date, data1, data2, data3) " & _ "select '" & format(date,"short date") & "','" & rcd!data1 & "', " & _ "'" & rcd!data2 & "','" & rcd!data3 & "'" DoCmd.RunSQL (strSQL) In this example rcd is going to be the record source...

It worked perfectly. Thank you:)

thank you. that did work, but where did it put the file, and what did it call the file? Is there any way to set these options?

Can anyone tell me how to create a new, blank Excel file from access VBA?

Using the trick on the tread I was able to get Excel to release my report file:) But I was unable to get it to stop the rogue excel processes that keep popping up. But that is of no big deal to me. I can deal with that:) thank you both:)

I have a form that takes data from a database, and creates a report in excel. I finally have this working. The problem is that when it is done, I close the workbook, but it never closes excel. Excel still runs in the background and does not let go of the file. So far the only way I have...

I don't know if this is the place to ask about this, but I cannot find anywhere else:( I have a couple of access tables altamatly after processing through I have a single query that has all the data that I need. Because of the folks who want this done are less than computer savy, and they...

I have an select statment that pulls data from a server. This server is really slow, and there is quite a bit of data. This statement has the following where clause. "WHERE upc_number = '" & strPikWhere & "' AND ((dbo_root_description_type.description_name)='PFMS' Or " & _...

I currently have a recordset that I need to put into a local access database. This recordset is being pulled from a server. I am currently reading in this recordset one record at a time and pushing it into an array. I am then using an insert into statement to push this array into my access...

I apologize I should have been more clear. What I actually need to do is to change the color of a single cell. the datasheetfontcolor changes the entire sheet, not just one cell and the fontcolor does nothing.

Can anyone tell me how to manipulate a single cell in a datasheet view, or if it is even possible?