Search results

Good day everyone. I thought I had everything set correct, but it would seem not. I am trying to have a table, where we can track what area's of the building people were employed. Many employment areas to one employee. Problem being, when click on the "Area of Employment" and the form...

Good day AWF, I've managed to get this to work using DCount, but realized that it's starting to bog down as it has to go through the whole recordset, which will only grow. So I've got the queries working fine, and by themselves the 2 DLookups, give out the proper filtered counts. But when I...

Hello AWF, been a while, but still been lurking. I've been down so many combinations that I've lost where and what I did. I have a master list of employee positions. Not all positions are filled by the employees. I wish to count the number of blank positions where an employee is not in to...

Greetings, Got an issue at work that was discovered, roughly 4 months too late.. yay for me for only one in the office who knows anything about Access. Found this as we were leaving/caluculating last minute monthly stats. So basically here is my issue. We have 2 access databases that gets...

Hey all. I got a form for stats tracking. A basic report nonetheless. I have a table called employees, with EmployeeID as the PK and a yes/no for a field with the name "attended" I have a report that has the employee table as the Source, and 2 values at the moment for it to calculate. In the...

Hi all. I have been tinkering with a Combo box on the main form, and it's selection will dictate what is displayed on the subform. I'm sure you are all aware of what I'm trying to achieve. I have googled for some tutorials, found some examples but didn't work. Anyone have a good example or...

Good evening. I'm creating a database in which when a new process verification is generated it is given a new record number. (2010-001, 2010-002, etc). My question is, I would like this number to be automatically generated once the user wishes to create a new "process verification". How would...

I have abandonded all hope of me getting this to work by myself and have came to well, here. I have searched the forums, and have seen many search/filter forms, but I can't seem to get them to work. I have tried http://allenbrowne.com/ser-62.html and just turns into one big fail. Been trying to...

Hi all, as seen by the screen the prompt is looking for the CustomerControlNumber from a table. Now is there a way to have the prompt read "Enter your Customer Control Number" instead of "Form!SupplyData-Input!CustomerControlNumber"

Hey all. I currently have a database that we have to enter any stock ordered and received. Problem is, is when we have to enter the data into the database, we also have to hand write out a form for acquisition of that item. Is it possible to enter your data into a form, and once all you info...

Hi all, I've been fiddling around with this database all night trying to get it work. I'm using Access 2007, and I believe the problem happened when I converted to 2003, as work only has a license to use 2003. Or when I tried to create another button on the "Supply Query Switchboard" form(> 14...

Hello all, tried searching in the help file but no luck. Same with the sites search function. Novice question here, that I'm obviously missing. When I open up a form, the form opens up behind the current form, thus making me minimize the other screens to get to the form I want. Where is the...

Basically. When I try to create a "New Demand" and hit "Print, save and close" It tries to print off every demand available (60+ pages). And I only want to print off one. I've tried everything I could think of, but no luck. Hence why I'm here. Link to program...

Hello all. Been scratching my head for awhile now at this. I got most of what I need to do completed, just this search function is giving me a headache. I'm relatively new to M$ Access, and I have the majority of my project done thus far I believe. Can you guys please help me our with the...

Hello fellow access users. I'm new to the access world but have already realized its potential, and so I took a course to learn the basics of access, and I've been tasked to try and create/modify a database for work. In which the user that created it did not make it edit friendly. And guess who...