Search results

  1. A

    Adding multiple data to one field

    I would like to be able to have the date written in to a field when another field is updated. Pretty simple, however, there are circumstances that this field could be updated as many as 6 times. I will have to build a query that will search this field for specific dates so I can count...
  2. A

    Updating records based on form data

    I am looking how to build the code so that if a form you have open has a value of 0 in three different fields, I can press an update button at the bottom of the form and it will place the current date in another field on each record. To explain better (hopefully), I have three check boxes on a...
  3. A

    Vertical Reporting

    I have read through the other posts and am not sure which way to go. I have a table that has 4 fields in it. What I want for a result is to put this in a column format. The four columns are a date, a name and then two numerical field values qty and reject. This data covers a lengthy period...
  4. A

    Multiple Criteria Query

    I have a table with 14 fields. I am looking to pull up records based first on a user input to match one field and then all records that meet a criteria of three other potential fields. My code is as follows: SELECT Bcone.Job, Bcone.ID, Bcone.Customer, Bcone.Desc, Bcone.Code, Bcone.Element...
  5. A

    Coversion of Text to a number

    I have a database that has been working fine but one field was listed as text. As it turns out the field is used strictly for numbers and we would like the reports generated to be grouped by a sequential list of numbering from that field. I simply converted the field to a number type rather...
  6. A

    Question Copy external files to the database

    I have gone through the forums and have found some helpful answers but I lack the skill to close the loop. My database is updated several times a day and receives its data from a CSV or TXT file. My problem is that I need to clear the text from the file when it is updated in the database...
  7. A

    Duplicate Values

    I have a handheld barcode scanner which sends data to a CSV file that is then imported to an Access 2003 database. From the import table, the data is appended to a user table with primary keys set to prevent duplicate data. I use 5 fields to make a primary key. The problem is that we update...
  8. A

    Update Query from Form

    I will attempt to describe this well but may struggle a bit. I have a table for a 2003 Access dbase that originally had 7 fields. I have added an 8th field for easier categorization. Let’s call field 1 job and field 2 dept and field 8 actions. I have built a query to have the user input...
  9. A

    Best way to perform math functions

    I would like to know how best to address performing basic math functions from queries from a single table. I have one table that I run a query to get a certain group of data from. I am attempting to get a percentage so the way I do it is count how many records I have with one criteria and then...
  10. A

    Check Box and Date

    Here is what I want to happen: Uncheck a check box that changes a value from -1 to -0 in a field. When that happens, I want a (now) date/time filled in to a field of that record. I am willing to use two clicks to make this happen if needed as the user will be working off a form, and I can...
  11. A

    Combo Box Data from another Combo Box

    I have read through the forums and followed the data but cannot seem to make a simple daisychain. I have a single table (bcone) with 13 fields (job, customer, description, etc.). I simply want to allow a user to enter data in the first combo box (Job) using the drop down or typing in the data...
  12. A

    Duplicate file input or a better idea

    I have three devices which will upload data to a single CSV file each day. I have a database (Access 2003) to track and sort the data once it performs a transfer text macro from the CSV file to the database main table. I would like to purge the original data automatically from the CSV file...
  13. A

    Simple Report Number

    My apologies as I am no VBA programmer. I am simply trying to add a report number to a header on a report. The report number should sequentially change each time the report is generated. I have followed about two days worth of effort based on the other submissions on this website and have...
Back
Top Bottom