I've created a query based on 3 related tables. The goal is to create a form based on the query to view and add records.
I know my query is not correct because when I run the query, I can see the record however, I cannot add a record.
Can someone explain the theory behind the query I am trying...
Trying to build a flight time tracking database.
I’ve created the tables with all the info that is needed for the app, and set relationships the way I think they need to be.
tbl_Flights : tbl_Leg (One to Many)
A flight consist of 1 day.
Each flight can have many legs.
I’ve created a form based...
In a column, I have the following text. MNET_1.WriteData[1]
I need to fill down to MNET_1.WriteData[960]
Selecting and dragging down does not increase the bracketed number, nor does adding 1 to the previous cell.
Not wanting to manually enter all the number, is there any way to accomplish this...
I've downloaded the Contact Management Database template and was wondering about these two query statements.
The first and second columns are expressions.
File As: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[Company],[First Name]),IIf(IsNull([First Name]),[Last Name],[Last Name] & ", " &...
Working with a vendor table.
There can be many different vendor companies we order from...
Within the vendor company, there can be different contacts according to department.
How do you structure a table accounting for this scenario?
Example:
Company XYZ has several different locations...
Morning all!
Quick dumb question....
When creating a contact table, and the contact has a physical address that differs from the mailing address, how is that usually handled?
Are both address' in the same table or, are the address separated some king of way?
Cheers!
-Kyp
Morning all.
Trying to educate myself on how to update a record selected from a list box on a form.
This is what I have and while it somewhat works, it's not correct. Errors listed at the end of the post.
Form Name: (Cost Center Details)
In the form, I have an unbound list box...
I have seen this expression in several places.
Would someone please explain the theory of operation.
File As: IIf(IsNull([Last Name]);IIf(IsNull([First Name]);[Company];[First Name]);IIf(IsNull([First Name]);[Last Name];[Last Name] & ", " & [First Name]))
The reason I ask is that when I...
I have not been in MS Access for a while. When I was using access, I was just learning so I am back to square one.
I have two tables, tblVendorCompany and tblVendorContact. I've created a "One to Many" relationship as pictured below.
What type of query do I need to create to combine the two...
Hey gang!
I an trying my luck with a tab control within a form.
I only have 2 tables, 2 queries, and 1 form.
The 2 tables tblEmployees, and tblContractors are almost exact.
The 2 queries qryEmployees, and qryContractors are also similar.
The form frmPersonnel has a tab control, with 2 tabs...
Gents,
After ready lots and lots of info provided by you guys, I've laid out my data tables in an excel spreadsheet, a different sheet for each table.
I hope you guys don't mind taking a look and let me know if I am on the right track here.
I haven't put anything in access yet, just preliminary...
Hello gang😊
I have started an access project and after searching the forum, I have a couple questions on table structure.
Questions:
I've read in several threads that I should NOT use any type of "Lookup" in a table structure. No "Combo Boxes", or "Value List", period.
I understand but why...
Hey guys,
I am starting an access project and I’m sure than I’m going to have questions!
I do know how to use the search function and will do my best to search the threads before posting a question.
Cheers!
-Kyp