Search results
-
A
Solved How can I run this update query without messing everything up?
Hi all, I have an MS Access 2007 database where I keep contact details of people. Data is input through a frm_CUSTOMERS and sent to the table tbl_CUSTOMERS which has the following fields: CUSTOMER_ID FULL_NAME (text field) ADDRESS (text field) COUNTY (lookup from tbl_COUNTIES) POSTCODE (text... -
A
Primary key based on field's content
Hello to all I have a large Excel file from where I will be importing data to a table. This file has two main categories, COM and RES. Entries can either belong to a COM or to a RES, never both. I am looking for a primary key generated by Access 2010, which will consist of the COM or RES... -
A
Assign values from the last record
I was looking for a way to assign values to fields from a previous record. After trying Microsoft's solution (that didn't work), I searched and found this article which worked like a charm. The only problem is that when I use the code in a form that has had no previous records, Access pops up... -
A
Form to enter multiple entries simultaneously
First of all, sorry for the lengthy post... I have a tbl_APPOINTMENTS, and I have created a form (frm_ADD_NEW_APPOINTMENT) that allows the user to enter an appointment for a person in a specific date. I would like to create a form (or edit the existing one) so that I can use a choice among the... -
A
Open a form in a specific record but in different state
Hi to all! I have a form "Products". I want to add two buttons, one named "See photos" and one named "Assign photos". Both of them will open the same form "Photos", but the first will open the form in a state that will not allow the user to change anything, while the second will allow the user... -
A
Adding multiple photos to an item
Hello to all! I am building a new database and I'd like a bit of help The database stores various items for which there will be 1 or 2 or 3 photos of each, along with other fields such as description, date of acquisition etc. How exactly do I create the table so that I can store 3 pictures on... -
A
Invoices table(s) with one invoice refer. to multiple products
Hello to everybody, I want to create a database that (among other things) will be storing invoices coming from suppliers. These invoices have a single number, multiple products with their respective prices and tax (each product can have different tax, 9% or 19%, but that can change in the... -
A
Button from subform opens wrong record on other form
Hello everyone, I have a form named SearchResults and a subform named SearchResultsSecondary. Inside the SearchResultsSecondary, I have a button that, when clicked, runs a macro named pass2form. This macro, is supposed to open a form named CHARGES in edit mode, filtered by a query named... -
A
Which way should I go?
Hi to all! I have a question that I can't find a logical answer to, especially after 3 days of thinking, I think I can't think anymore :o( So here's what's going on: I have a Clients Table (*CLIENT_ID, NAME, SURNAME) I have a Products Table (*PRODUCT_ID, DESCRIPTION) I have a Charges Table... -
A
Two forms to run the same query
Hi to everyone! Here's the problem. I have two forms and each one has a button that will run the same search. The search is actually importing criteria in a query. FormA has a button named FINDCLIENT that passes the Cient_ID to the query and runs it. FormB has a button named FINDCLIENTB that... -
A
Sub Form returns wrong data
Hi to all! I have a pretty complex problem with a form and a subform and I really can't think what to do... First of all, the main form keeps appointments. The screenshot form1.jpg shows the main form with an appointment from the client named KAPEZA TATIANA (not a real person ;o) ), the... -
A
More than two combo boxes in a form
Hello to everyone! I have a serious issue to solve and I would like to ask for your help, as I just don't seem to know how and where to start from. I need to make a database that will have 2 tables, say tbl_item and tbl_offer. The items table will have different cardboard dimensions and other...