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...

Thanks pbaldy and Pat. I really appreciate the help. I did what pbaldy suggested and it worked, although I'm not exactly sure why. What does the number sign do? (Sorry, I'm new at this, I've been learning on my own so there are some gaps). I checked and double-checked each of the forms (main...

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...

Aha, works great now, thanks Bob!

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...

Thanks John and Isskint! It worked perfectly, plus I think I have a better understanding of the how it all works too!

Hey Thanks again, yes that totally makes sense, and I will use it to try and persuade the bosses to update the way we number our samples.

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 lagbolt, thanks for the reply! Unfortunately I need to keep the format consistent with past years for now since there are a number of people and programs set up to run on the old format. I'm definitely looking into a more straightforward numbering system and hopefully I will be able to...

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...

Thanks Pat! I have a follow-up, when you say that the number I show as an ID won't work, is this because I don't give one to new records before appending them? I can't see any problem with doing an update query based on these ID numbers, since each record has a unique number (it is not an...

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'...

I'm not sure whether or not this is accurate, but in Canada, most of the guns are rifles or shotguns and are owned by hunters and people who live in rural areas. I grew up in urban and suburban middle-class neighborhoods, and I've never known anyone who owned a handgun, let alone a...

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...