Search results

Hello, I have a table called tbl2A. I want to open this table as long as there is some data in it. I have the code below that works very well. strSQL = "select * from tbl2A" Set rcd = CurrentDb.OpenRecordset(strSQL) rcd.MoveFirst If rcd.RecordCount > 0 Then...

This is a very complicated query. I have two tables, tblFromBob and tblGenCol. tblFromBob has the below columns. Sim is the PK. sim cat_no tblGenCol has the below columns. Sim and Generic_col is the PK. sim generic_col Identifier now what I need is the sim, cat_no, identifier_1...

Hey all, I am using Access 2010. I have two tables, tblInventoryItems, and tbl2R. tblInventoryItems is just a list of items we have in out inventory. It has three fields, country_code(int), sim_mfr_no(text) and sim_item_no. The tbl2R is a table with a number of replacements. tbl2R has the...

I have a question, and am not sure where to put it. I currently have an application that is currently an access app, but will need to be ported to vb.net. The problem I am having is that it creates an excel report. To format this report I simply created macro's in excel and pasted them into...

I have a form that has a group of text boxes. The top one is a customer box and the rest is unimportant. What I need to do is to fill in the unimportant tesxt boxes on the change event of the customer box. To do this, I have to setfocus to each box individually update their information, and...

I have a string that has only a function name in it. I want to call the function name that is in the string. my function is called goodtime. I have the following code. Public Function goodtime() As String DoEvents goodtime = "testing" End Function strTemp = strAnswer & "()"...

here is a description of my excel file. there are 12 worksheets, each representing a month. each of these worksheets has 3 columns branch, customer_no, price I have a 13th worksheet for totals. I need to get the total price for each month/branch/custom. example output month branch...

I have a program that is pulling data, and for reasons of speed and memory I decided to use comma delimited files to store the data. This then does some calculations on the data and then exports the data to an excel sheet for a report. The problem is that one of these files is over 200MB in...

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 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?

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

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...

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

I have two subforms. They are in nice neat grids as access setup for me. Both of these forms should have similar data, based on a upc. What I need to do is turn the text of an entire row to red when there is no matching upc in the other subform. The two problems I cannot figure out is as...

I am using Access 2003. I have three databases on three different servers. I have a program that query's each of these databases. Each query takes between 3 and 4 minutes. Right now my program takes between 10 and 12 minutes to run. I was wondering if it could be multithreaded to run all...

I have a form that connects to three different databases on three different servers. Each query takes about 3 minutes. When run this form takes about 9-10 minutes to load while the servers are busy. I was wondering if it is possible to multithread these queries and run them all at the same...

I have a form that has an image name. The image is stored on a web server. The image can be accessed through a URL. The problem is how can I show the image on my form. When I try to change the picture property of my image control it tells me that it cannot use a web address. Any help would...