Search results

I am trying to populate a listbox with an ADO recordset that contains data with internal commas. Normally, I just double-double quote these and everything is fine: Do Until rs.EOF Me.MyList.AddItem ("""" & rs!MyField & """") rs.MoveNext Loop But this time, the listbox is not getting...

Hi, all. I have a text file that I want to import into an existing table in my Access 2003 database (via Access 2007). I used the import wizard to import the data once and saved the steps as an import specification. I want to use that specification in some code to automate the process. Here's...

Hi, everyone. I need to create a summary report and I'm having trouble constructing the query. Here is a representation of my data table: FARM WORKORDER SURVEYDATE PESTCOUNT MyFarm 2009001 6/12/2009 10 MyFarm 2009002 6/15/2009 5 MyFarm...

Hi everyone. I have a database I built in Access 2007 (using the older mdb file format). Everything works well. In a bunch of forms I have dropdown boxes that are populated using sql statements in their row source property, such as: SELECT pID, Package FROM (SELECT [pID]...

Hello everyone. I have a report that basically has one summary page per client. Originally, I just ran the report without filtering it, so all clients were included. But now I would like the option of choosing to include all the clients or only selected clients in the report. I built a form...

Hi everyone. I was just wondering, is it a problem to try and establish a connection and grab a recordset via ADO to an Access database that someone else has open? Could you hurt the database if you try to do this? The reason I ask is because I was writing a macro in Outlook this morning. My...

Hi. I searched the archive through Google, but didn't find what I was looking for (though it seems certain that this question has been asked before). I have four reports, all generated from the same query. The only differences among the reports is the way the data is grouped. Is it best to...

Hi, everyone. I wonder if people could share their experiences with ensuring quality control in data entry. Specifically, I have a database that office staff enter work order data into. I want to make sure that all of the work orders have been entered correctly. They are usually entering them...

Hi, everyone. I have a Farm table that contains data associated with individual farms. Each farm occurs within one county and one state. I also have two control tables, a County table and a State table. There is a one-to-many relationship between the State and County tables. In my Farm table...

Hi, everyone. I want my form to save the record only when the user clicks the Save button. If the form is closed in any other way, then discard the changes to the record. I found a thread on bytes.com that addresses this: http://bytes.com/groups/ms-access/835113-force-user-save-form-data...

Hello. I was wondering if anyone could explain the differences/benefits/drawbacks of these two approaches to opening a form: DoCmd.OpenForm "MyForm", ... and Form_MyForm.Visible = True Duluter

Hi. I've been thinking about creating a log of all transactions in my database as a safeguard against data corruption. If I had a log that consisted of ordered SQL statements, the database could be rebuilt up to the last successful update via those logged SQL statements, right? In my database...

Hi. In my VBA modules, I connect to my data through ADO. I would like some feedback on the way I do things to see if I could be doing them "better". Background: The database is used in a small business, with usually no more than one person accessing the data at a time. Occassionally, there may...

Hi. I implemented a query very similar to one found in O'Reilly's SQL Cookbook on page 367 ("Pivoting a result set into multiple rows"). Part of the query uses aggregate functions (MAX, in this case, though the exact function used is arbitrary) to remove null values from within columns to bump...

Hi. I have a report that groups on field X. Under each X, there may be multiple records showing fields Y and Z. X1 Y1_______Z1 Y2_______Z2 X2 Y1_______Z1 Y2_______Z2 Y3_______Z3 Etc. Standard stuff. Now for each group on X, I want to display a label to the left of the first detail row, but...

Hi. My testTable table has two fields (words and current) and looks like this: words______current ten_________no this________yes half________yes question____yes fibber_______no I want to query the table to find all the words that are "current", like this: words___ this half question But...

I have two tables, tblWorkOrder and tblSubWorkOrder. There is a one to many relationship between them. I want to pull the work order ID from the tblWorkOrder table and the Acres field from the tblSubWorkOrder table. Here's my query: SELECT tblWorkOrder.pkWorkOrderID, tblSubWorkOrder.Acres FROM...

I want to import data from three DBF files into three existing tables in my database. Following a suggestion from another forum user, I am using the following code, where tblA, tblB, and tblC are my tables and DBF-A, DBF-B, and DBF-C are my three DBF files. CurrentDb.Execute "DELETE * FROM...

Here's my scenario: I have an Access database into which I import data from three DBF files on a regular basis. I get the DBF files from a third party and I replace my existing data with the updated data when I get them. I import the files as three separate tables, call them tblA, tblB, and...

Hi, all. This seems easy, but I've looked up and down and can't locate posts that clearly answer this question (though perhaps my search terms weren't good). My Situation I have two tables, Client and Project. There is a one-to-many relationship: each client can have many projects associated...