I have a table that functions as a subtable. This subtable contains a list of chemicals in one product. This table of chemicals have two fields - CAS and NAME. The same CAS always has the s...
When I import some data into Access using an import spec and set an autonumber to use as the primary key, Access rearranges some of my data and puts things in the incorrect order. I will be i...
Can someone explain these boxes in access?
and what does it do?
The original database is at www.dropio.com/tasksdb but will probably confuse the issue.
From the standpoint of only tables, the following is what I am trying to accomplish.
Note the date...
Hey Experts!
Can you help me please?
I have a few inventory tables in a database;
Table1 has columns: user name, pc asset number, laptop asset number, location and dept
Table2 has colum...
I don't want the user's to be able to close the database itself using the close button for the database. How can you hide the close button and minimize / maximize buttons on the database window?
MS access
I have tables with a one to many relationship.
I want to replace a date field in the one table with the date from the last record (latest date) in the many table. Is it easiest to ...
Our HR Database is currently experiencing issues whilst running over Citrix.
This is the application location command line in the Citrix Program Neighbourhood:
"M:\Program Files\Microsoft ...
I have successfully began a couple of Dbases in SQL 2000, but am having problems connecting to them through VB (version 6.5, in Access 2002).
Here's the error I get when I try to connect: R...
Hi, I am quite new at building Access and still have a spreadsheet mindset. I have 3 tables:
One with various products and their details
One with order dates
One which lists these products...
Hi Experts,
Thanks for your time and knowledge.
I have been asked to take a look at a database at work, I have a bit of experience with Access while no-one else at work does. The databas...
Hi,
How does the code need to be rewritten to access recordsets once an Access database has been split into FE/BE. The BE will reside on a shared drive, not on the local pc.
Here is a po...
The temporary locking file (.laccdb in Access 2007 and .ldb in all prior versions) that is created when a user is "in" an Access database, contains info on sharing the database.
I'm wonderi...
hi all
Some of my queries do not fit in portratit, but only landscape, so each time i need to print i have to go in to page set up and change the settings from portratit to landscape. may i...
I am building a database that will serve as a workflow management system for 50-75 simultaneous users (150-250 unique users altogether). In short, my question is: Is there a better way to org...
I have a user without Access installed. They need to view an Access 2003 databse. Not sure what to do and I don't want to install Access.
I'm using v11.11 and everyone has a different way of connecting to these servers. We cannot turn on trusted system and so logging is minimal. If I wanted to have the ability to at least go b...
I have a table called Document containing various info on each different document (primary key is an autonum DocumentID). I want to link two documents to each other to be known as Like Docume...
I would like to setup a criteria in an Access Query with a specific date range. Here's some sample data in the different fields.
C1 C2 C3 C4
1/1/08 Name ...
Hi,
I need some help with designing my database.
Tables: UserDetail, Searchable, Message
UserDetail has a detail description of each user. Searchable table is used for the user to bloc...
I have two tables in my Access Database. One labeled Requirements and the other labeled Analysis.
The Analyses table has multiple entries about the requirements used for that analyses (All...
I am joining multiple queries in a union query in sql and the data is formatting in random fashion. I then add this Format([Step 6: Final Summary].Shipmentsize,"0.00") which fixes it, but now ...
In the following table: tbl_ComputerSoftware I need to be able to show all of the software we have on hand and the software currently assigned to a computer. If we uninstall some software it h...
I have 2 databases in Access 2003 with almost the same data. I've combined the tables into one and now I want to remove all the duplicates. I don't see any wizards or simple way to do this. ...
Objective: Store and retrieve members attendance to meetings.
Tables
Members
ID
Firstname
Lastname
Meetings
ID
MeetingNumber
Attendance
ID
MembersID [lookup int...
