Search results for query: *

Hello all- I have created a combobox which shows 7 columns when the user clicks it (bound column=1). The Rowsource is based on an automated Excel Export that I have some control over. There is NO primary key on this Excel spreadsheet (if that's even possible) and the bound column I've chosen...

Hello all- I have a form where I am asking the user to add serial number information located in 4 places on the product. For user clarification, I thought I would try to show a serial number locating picture when the GotFocus event fires in each serial number textbox. Now, in the past, I...

Hello and thanks for reading! I was asked to create a database to contain a library of information coming out of a piece of equipment we use. I worked on that a while and have it importing the .CSV file that is produced by the equipment. No problem.... Now I am asked to push some portion of...

Thanks for reading! I have a field called "Comments" where, oddly enough, I am keeping text that looks like a date (long story, just laugh and keep going...). Now, I want to create a query that looks for records whose [date + 2 years] is older than today. In other words, if this field is the...

Hello- I have imported .CSV information into a temporary table called tblImport1. The difficulty is that the first 13 rows of info are header info, while the rest is data (see below). I'm wanting to move these 13 rows/1 column (Field2) into another table (tblHeader) with one row and 13...

Hello all- I am trying to automatically update a table in my database with the latest Excel files that become available online. Specifically, files from this website: http://www.defensetravel.dod.mil/site/perdiemFiles.cfm. The CONUS Excel files are typically updated once per year, but could...

Hello- I have a need to look up the record number (auto-numbered primary key) of the earliest (and latest) record in my recordset. I've been stuck trying to use DMIN and DMAX, but I find it does not accomplish what I want. As best I can tell, the field that it uses to search on is the only...

Hello all- I've been using XP until I was recently converted over to Windows 7. I have been very successful with Allen Browne's solution for obtaining file properties (until now): [link]http://allenbrowne.com/ser-59alt.html[/url] I've added a little code to this and will give it below...

Ok, I am trying to display a report which has a subreport in it. I'd like to have a new page each time the manufacturer (located in the subreport) changes. I did group the subreport on manufacturer. I've moved the manufacturer to the group header AND left it in the details section for the...

Hello! I need help summarizing data for a report. The report needs to show a running 12 month history of the number of "findings" opened in a given month. So, in Excel-world, I would have used a "countif" function on every month column. I have tried to use pivot tables and crosstab queries...

Hello! I've recently created an Access front end for SQL server (which uses what I am guessing is called GUID primary keys). In my form, I try to open a report based on the current subform record that is chosen via a command button placed in each record. This opens the report based on the...

Ok, this one is really weird. I am having problems deleting a record using my own code, so I: 1.) created a temporary command button using the wizard) to delete a record 2.) ran it a few times (worked) 3.) pasted this code into my code and ran it. The difference being that my code has a small...

Thanks for taking time to review my stumbling block. I am attempting to return a "First Pass Yield" query. Let me define this requirement: 1.) For a given month and year chosen in a FPY form (frmFPY), I'd like Access to only return those units that were tested for the first time in the given...

I have a form that is being filled out. I need to prevent duplicate entries (a duplicate is defined as ALL field values from one record match ALL the field values on any other record). Now, I've used Dcount quite a bit, but I'm having a little problem here. I can get no value for Dcount...

OK, I have a general strategy question. I am used to creating records that store related tables' primary keys. For example, when I put a customer name in an order form, I store their key, not the name (243, not John Smith). I believe this is the standard way to store info. It allows me to...

So, for all my ADHD friends, I'll ask the question first, then give all the boring details next.... Any ideas on how to force an unbound textbox's value to update each time I press a keyboard character? Now the details.... I have an unbound textbox that I am using as entry for a Google-like...

Hello all! I have created a few multi-user 2007 databases. I have always chosen the "Compact and Repair" option on close to prevent bloat. However, on occasion, the .accdb file will be missing, but a "database.mdb" will appear causing everyone's file links to quit working until I rename the...

Hello! I am trying to eventually give users the ability to search on files based on certain file properties. To do so, I thought it best to figure out a way to import properties of a given set of folders (and any subfolders) into a table. The properties I would need are the File name (not the...

Thanks for reading this question! I have a subform with an existing hyperlink which works well. The customer wants to see the word "MSDS" instead of the actual hyperlink. I tried to create a new field in the subform with the following source code: ="MSDS#" & [Location] & "#" where...

Hello all- I am having a weird problem and have done a lot of Googling before posting, so here goes: I have a form that I want to use as both new record entry and existing record review. On entering the form, the default setup is to look at the existing records. When the operator presses the...