Search results

I am on a networked computer and I am building a program that is going to be placed into my local network. I have to create password protection through the workgroup information in access. I do not fully understand how workgroup information is used, when I check the current data on any of the...

I have a button that runs an append query, my concern is that I only want to run the query a maximum of one time per record, each time a new record is input I would like the query to append so that a value can be added to my 2 tables. In order to do this I decided to start the button as...

I've considered using an append query that is activated through a command button for updating the current record, my only concern would be that if the user does not click the button the information still enters into the main table but not the second table. And I'm also unsure if the append would...

Using: Access 2k3 My problem: I have a table 'tblemployeeinfo' which contains, among other things a field for employee name and a field for wage. I had initially used this table to populate many list boxes for inputting employee information. When I decided to tackle database security I noticed...

Ok, I'll try that. Thanks!

I'm working on creating a query based on another query that simplifies results into yearly records from monthly (so that all records of a given year will be shown as a sum). What I have done is created a query with the fields that I need to have shown, including 'fldyear', in 'fldyear' i would...

Ok I got it, Thanks to you both for your help! You're both amazing!

Thanks for your quick response. OK so my list box currently has Name: Employeename Control Source: Employeename Row Source type: Table/Query Row Source: TblEmployeeinfo You're saying: Row Source: WHERE ((([tblEmployeeinfo].[Full or Part Time])="Full Time")); I tried this and recieved the...

Hi there, I have a set of forms for employee time sheet information. In one form data about employee burdens (vacation, sick days, etc.) is entered. This information is only pertinent for full-time employees. My problem: my list box takes the 'employeename' field from a table to populate...

Figured it out. I did it by changing my values so that they'd match up in an UNION Query, for those who care.

UPDATE: Ok, what I have done as a temporary solution is to create an empty employee that has 0 hours in every job. This will not work as a long term solution though, as it displays no data when I attempt to search by month or year. Essentially what I require is an addition to my three sets of...

What I have: 2 queries: Q1; Jobs Via Truck (total cost) Year Month Q2; Jobs via Employee (total cost) Year Month Both queries *should* overlap so that the hours spent in a truck and by an employee on a job would be equal. *BUT* I want to ensure that if the values do not overlap exactly...

Ok, I understand. Thanks for the help!

Haha well, you have the jist of my total plan, my current problem lies with the sampleinfo part of it. We take multiple samples from each site, but they go out as one set. So I'm trying to set up a report that will let me record multiple samples for each site by using a subform for each sample...

Hi there, This question is probably going to sound more complicated than it actually should be, but I will attempt to make it as clear as possible. I am attempting to make a simple database to track chain of custodies for laboratory samples. What I have: 3 Tables: Table1- SiteLocation...

Nevermind, I figured it out. I appreciate your help!

Thank you for the prompt response. Your answer is much clearer for what I am trying to accomplish. I would love to say it works like a charm, but I appear to have hit a snag. I used the syntax: IIf(([Queries]![qryGLUsed]![GL]="G-320-715-6302") Or...

Hi there everyone. I am trying to create a report that displays a set of numbers (based on certain job types) and their corresponding price. I have this working up to a certain point, but I have a slight snag. 2 of the numbers are created from a list of multiple jobs and the season they occur...

For Example... If I only had 1 item, and decided to calculate price by average and price was in terms of $/base unit. So Item1 has 20 base units in store at a price of $5/unit, and then there are 40 items purchased at $4 per unit, the average price should now be..$4.50/unit. Where could I store...

Just a question regarding the use of the average price. If I am recording multiple inventory movements both in and out how do I manage to keep track of a changing average price on inward inventory without actually storing it's data in a table?