Search results

This is kind of a long post, both questions are related to a similar topic of dealing with a large number of buttons. Question 1: I am attempting to make a macro to pull information based on a clicked button to provide information to another form. While my example below will be rudimentary, I...

Happy Holidays everyone!! I had a question but I'm not sure if it's best suited for queries, coding or macros, it involves a query so i'm putting it here. However, I believe that code and/or a macro may be necessary to accomplish what I am looking for, so i'm going to break it into the three...

Hi everyone, So I've used this syntax before on many union queries and it has worked. Yet for some reason it now refuses to work on my new queries. I know that some of you will be annoying with my naming conventions for this (but unless that is where the problem actually lies, you don't need...

I have a select query, and if I accidentally alter information within it's results it automatically alters that record in my table. Is there a way to stop this? ConfusedA

My problem: I have a set of reports that are created by a lot of queries. These reports collect together a bunch of information to create a totals section, my current problem is that there will not always be values for every field for each of the specific ways in which data needs to be...

Using: Access 2k3 What I have is an input form for inserting inventory (type, amount, price, etc.) I use an append query to place each type in to another table. If the object is already in the table i'd like to be able to use an update query just to update the values. The query would be...

I wasn't sure if I should post this here or in the code section. Relevant Info: Using Access2003, connected to: http://www.access-programmers.co.uk/forums/showthread.php?t=174345 What is involved: 3 tables. 1 Form. Tables Tableprice: Item Quantity Current Price(which changes based on...

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

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

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

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

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

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

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

This question is directly related to this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=174814 I am trying to figure out how to code in a query so that I can apply one of two numbers to a record based on it's seasonal value (which is determined by the month given for each...

I've tried a few searches for something along these lines, but I cannot think of what to search for, if you read this and know of a previous conversation along these lines please pass along a link, or if you can help it'd be appreciated. The data: TableJobtype: I have a list of jobs that are...

Ok heres my problem, I'm building a search program that allows for multiple fields to be searched in one go. So I have a big query connected to a form with form objects associated to each field of the query... For example: There is a list-box for Job types: Road Reconstruction, Sanitary, etc...

I have used basic code that allows me to ask for a password to be input in order to enter a form from another form, but you can still access the form and the table info from the database menu, how can i put a password on to the form and table in question so that it cannot be accessed in the...

I am trying to build a database that includes inventory information. What I am trying to do is have a way of storing a base (yearly or quarterly) inventory and then every time a job uses material it will be recorded and a search of inventory can produce inventory used and/or current remaining...