Search results for query: *

I am trying to find the highest value in a table and increment it, putting the new value in a text box on a form. Everything I'm doing works fine on my workstation with full access-2000 installed. It fails on workstations with the access runtime "The expression After Update ... function is...

I am trying to find the highest value in a table and increment it, putting the new value in a text box on a form. Everything I'm doing works fine on my workstation with full access-2000 installed. It fails on workstations with the access runtime "The expression After Update ... function is...

I have created a ms-access 2000 program, but I am wanting to move parts of it (and eventually maybe the whole thing) to a web based application. For some reports, basic queries, or simple data entry, this will be much faster than the large and slow front end I have now. I would also like the...

I have a front end MDE file and back end MDB on a network share. I am using the access 2000 runtime to make this available to ~40 users. This has been working fine so far. I just ran into two computers that won't open the file after installing the runtime, I get a null result when clicking on...

I havent worked with classes yet, but have read a little. I have several excel files connecting to my back end, opening a recordset, and manipulating data in the excel file. This is not the best setup for maintainability. I am thinking I could make a data layer in the front end that can be...

I have a Bill of Materials (tblBOM), and a list of items from purchase orders (tblPOItems). Each PO Item has an BOM Detail Number, Ordered Quantity, and a Received check box. Now I can build queries that show a sum total ordered quantity for each detail number, and a sum total received...

The main screen of my database is bound to this query, it's always open and is the primary interaction with data. I am trying to optimize the speed of things (I have been through all the standard FAQ's) and want to scrutinize this particular query. There are about 4,000 job #'s, but less...

I have a series of MEMO fields that contain a running history of changes. I need to convert this memo text into proper records in a new table. EXISTING MEMO EXAMPLE: \-- 4/21/2009 10:52:01 AM; John D.; --[CustomerID]; null; 289574; --[Contact]; null; Jane Doe; --[OrdEntryDate]...

In researching barcoding, I am thinking that by using a "keyboard wedge" type scanner and encoding a custom shortcut key sequence into the barcodes themselves, I can practically print macros on paper. This way anytime a user scans a barcode, with any form open, a function can be called...

Access 2000 MDB backend and MDE front end on network for 18 total users, 4-6 concurrent. My main interface is a complex form with about six sub forms, all based on queries. The main query joins four tables (~85 records), another one joins two tables (~50 records), the other two are a based on...

I am building a form to import and validate data from an xls form. I want to establish a recordset and begin looping to import data to a temporary table. If I use rs.open with a SELECT '' AS Material INTO query I get a blank record. How do I create the temp table with no records?

I am setting up a purchase order system and have decided to add new records using VBA, and also deleting them if certain conditions are not met. I started to implement this with docmd.runsql and warnings turned off, but now I wonder if its better to use recordsets, particularly in case of an...

I list purchase orders in a subform linked by job number. The list displays items from tblPOHeader. A second table tblPOItems contains line items, a single purchase order can contain line items for many jobs. I am writing a query for the sub form so that the header fields are repeated for...

I am building a complex interface, the main form is blank with two sub-forms. The recordset of each subform is linked via code on the main form. Set Me.SubFrm2.Form.Recordset = Me.SubFrm1.Form.Recordset In this way, when you select a record from SubFrm1 (list view) you can edit it in...

I'm making a report to replace an old handwritten form. I have a sub-report that spans the page with five fields and all looks good, except that it only prints as many lines as there are records and leaves the rest of the page blank. I would like to fill the page with lines for visual...

I have a "Jobs" table with fields "Promised Date" and "Ship Date". As a job evolves, these dates are frequently revised. Then, after its done, a job might come back for rework and the dates are revised some more. I want to track on-time shipping, but under this model I cannot automate it...

I'm getting way out of my depth here, I know access fairly well and do a lot with VBA, but I don't know anything about programming or databases beyond access. We currently have several reports that get printed to PDF, then published to our intranet every one to two days. I would like to...

I need to consolidate some data for a calendar report, is it possible to build a union query like this? Query is used by calendar report, and sub-report (42 occurrences per page, ~6pgs). I am thinking about using a temporary table, but as it stands its quick enough. Input - Current query...

I made a query to return a single column of results, which I want to combine into a string value separated by commas. I wish to do this programmaticaly without the query. The query returns 0-10 results, so the string I want is "[record1], [record2], [record3], [record4]". If zero records...

I have a front-end / back-end database where both mdb files are on a network server (same folder). There are only three main tables, and a couple of complex forms. Typical 2-4 concurent users. Most forms and reports are based on queries (queries are saved in front end). 1) I have a table...