Search results

I'd like to know the code which will have one of the text boxes on a report look back at the same text box in the record right before it. If the value of the former textbox doesn't match with this text box's value, then this textbox's forecolor will be vbRed. I also need to be able to turn...

What's up with declaring an object as Database in A2k? I try: Dim db as ADODB.database and there is no ADODB.database. Is this declaration implied or am I missing a reference?

OK, got it. For future reference, I would like the code to loop through a recordset on a form, just so that I know how to do it.

If I'm understanding your problem correctly, use the combo box wizard. Select the third option "Find a record on this form based...". That will then display the appropriate record based on what you select (I should note that this particular type of combo box works best when the Control Source...

Hi all, I'm trying to accomplish a pretty simple task that I don't yet know the code for. In the On-Click event of an option button on a Parent Form, I need it to loop through all the records of the Subform datasheet and put the Number 0 into a certain field of every record. I'm using A2K, so...

I have several MS Access crosstab queries. I would like to link an Excel Workbook to these queries, one crosstab per worksheet. After linking and refreshing on open, I would like two things: 1. The Column Headings in my Access Crosstab are dynamic; they change daily. I would like for the...

I have a Switchboard which, when a particular button is clicked, Deletes all records out of a table, Appends several thousand records to that table, updates all of those records, calls a Select query to show filtered results from that table in a Report, and then Deletes all of the items out of...

This is how I would do this: You have four tables: SUPPLIERS Supplier_ID(autonum) Supplier_Name(text) Country(text) CATEGORIES Category_ID(autonum) Category_Name(text) PRODUCTS Product_ID(autonum) Product_Name(text) fk_Category_ID(Number) SUPPLIERPRODUCTS fk_Supplier_ID(number)...

Yes, your SQL statement is the general idea that I'm looking for, I'll get to work with this idea. Unfortunately, the Project Managers want every number in the database archived and they're actually trying to catch Techs when they report discrepancies. Since we're trying to compare two...

Here's a pretty complex problem that has me stumped: I have a hardware tracking database. I have a main form with a datasheet subform. The main form has information on the Site that was installed, the Tech who did the install, and the Kit that he used. The subdatasheet has a listing of items...

Yes, I agree. A rigid template coming into us would be the easiest answer. The Project Manager has tried to implement this, but Part Listings change daily, therefore the template has to be changed daily. Techs get confused on which template is the most current, so we end up getting a lovely...

No problem. I'll just call all of the queries separately. Since I will have to write them, it's really all the same anyway.

This is my issue: The db I'm working with is a hardware tracking tool. Every day, some 25 or so Techs send in Spreadsheets with items on the sheets and info on how many they used, how many were DOA, etc. Because there are so many techs and item listings, we copy and paste this data from the...

Hmmm. Yeah, I guess that would work. The only thing is that I would have to write 30 or so separate update queries and make 30 separate calls to these queries in the Click event. Logically, this would work fine, but I'm trying to cut down on new queries as I already have 80 or so written and...

Not quite so easy. I'm trying to make different updates in the same field based on different criteria. So my WHERE clause will be different for every criteria (or maybe I'm supposed to use IIF). In plain English, this is what I'm trying to do: -Update to the name "Image CD's" all instances...

Hi all, I'm looking for the SQL statement which will allow for multiple updates in the same field. Here is my current SQL statement: UPDATE tblSpareSiteParts SET tblSpareSiteParts.fk_item_name = "IMAGE CD's set (approx 15 disks)" WHERE (((tblSpareSiteParts.fk_item_name) Like "image cd*")); I...

Hmmm...So you're suggesting to have all objects that make calls to the back-end load when the db opens, have all of their Visible Properties set to False, and then set each object's property set to True when it is clicked on the Switchboard? How much worse would the initial load time be, as I...

Well, that definitely answers the first part of my question. I hate to reopen a topic that has been explored to no end in these forums, but is there any definitive answer that anyone has found to speeding up calls to the back-end? I've retested the split db and the sad fact of the matter is...

Hi, after several crashes making my db virtually unuseable in a multi-user environment, I have decided to bite the bullet and go ahead and try to split this thing up (previous attempts to split the db made it extremely slow, but I guess a slow db is better than an unuseable one). I'd like to...

Well, they're not "Find Record" combo boxes. The combo boxes take the Primary Key Autonum from the Teams table and are bound to foreign keys of different Site Info tables. They obviously will change the foreign key tables, but the Teams table should remain unaltered. This project has been in...