Search results

Hi, I have a combo box which gives the initials, first name, and last name of employees. When you select an employee, their initials show up on the form, while their ID number is stored in the underlying table (the ID # is in the first invisible column in the dropdown). The problem is that on...

Hi everyone, I have a few button in the header of a form, they are for closing, refreshing, or starting a new record. I arranged as I wanted them in design view, but in form view and layout view they change positions so that they are overlapping. It's not a huge problem, I can just space them...

Hi everyone, I have a form that has a combo box and the record source refers to that combo box. Until I added the form to a navigation form, this was no problem. The form (which is continuous) would just open as if "" (nothing) had been entered in the combo box. The form still opens fine...

Hi everyone. My code is working, but I'm new to vba, and I'm sure there are better ways to do this. The code is very repetitive and I think if I had a better understanding of writing functions and Do loops, I could make this code a lot simpler. Basically, it takes the selected records, opens...

I've read a few posts about date formatting in SQL, but I can't seem to get it right. I have an update query but the final date it inputs into the table is 30-Dec-1899. The format is right but the date is not. I have a pop-up form where I enter the date (the format is fine in both forms) and...

Hello, I'm having some trouble writing code to lock/disable controls after a certain event. Basically, I have a button 'cmdPrint' that brings up and fills in an excel sheet with a bunch of labels for sample vials with unique sample numbers. At the same time, when ever the print button is...

Hi everyone, I've been working on a form for my salmon database. Each DNA collection has a range of sample numbers (they are historical, I need to keep them as they are), so based on the location ID selected, I want to query the DNA collection codes already in use, and automatically enter the...

Hi Everyone, I have a bit of a complicated problem. I am creating a database for DNA samples. Samples are collected at a number of locations so I have one table that contains each location, and another that keeps track of each DNA collection (each collection has 100 samples). When I'm...

Hi Everyone, I'm having a bit of trouble with some tables that I was hoping you could help me with. I have three tables. The first is a large spreadsheet of data from another agency that I don't want to make any changes to (I'm just linking to this table). My next table is 'additions'...

Hi, I'm quite new to Access and I'm having trouble with a form I'm working on. It's probably a straightforward solution, but I haven't figured it out yet. For a bit of background, I'm collecting a large number of DNA samples from a variety of fishing locations. I have two main tables, one...