Search results

Chris, I reread your original post and now I realize your linked table is to a payroll program rather than an access back end. Sorry. Make a log table and a caller table in your access database with the following fields. LogID, EmployeeID, CallerID, CallBegan, CallEnded, Notes. CallerID...

Alico, your issue is really when you create a new record and you did not say how you do that. Do you open an unbound form to enter the information? Do you use recordsets or an append query? Do you use the arrow in the navigation row on the bottom of the form? As is often the case in Access there...

You are right, but the goal here is that the information is stored in one place and not entered into a table like a spreadsheet. Remember, spreadsheets are horizontal, databases are vertical. In Excel you insert a column, in Access you add a new record. If the value, weight and impact fields...

Nothing wrong with multiple foreign keys in a table; that constitutes normalization. Everything has a one to one relationship and there is no duplication. I am curious what you would want to do to change it. Let me know.

MCRetro, I don't know where you are doing all this, building a query or on a form, so I can't give you an exact answer, but it looks like you are referring to cascading combos. They work on a form where you have multiple combo boxes and the selection from combo one is used as the criteria for...

Chris It kind of does that automatically. If you move from one field1 to field2 the information in field1 gets written to the table. When you close the form, all the fields get "saved"; it's kind of what queries do. You can watch this. Open the log table and the form and edit the form. You will...

Another question is why do you have dates formatted as integers in Excel? A date in Excel is really an integer behind the scenes and 25 August 2014 is really 41876, so it's not for sorting purposes. You should consider editing Excel and creating a real date field before you import the...

I did not view your jpg, but my first impression is you need to build many tables. One of the primary tenants of normalization is to remove duplication. So with your example, you don’t store Bank of America in the transaction table, your database will be huge in size. Here is how it should work...

Chris First things first, you can add data through a query. You need to create a table with all the telephone log fields. Then add an EmployeeID field to it with type long and indexed dupes OK. Open a query and add both tables. Draw a line from the EmployeeID field in the Employee table to the...

A quick look indicates that your tables are not related to each other. In the three tables you listed, change the name of the ID field to ProjectID, PaybackID and NeedID; these are called primary keys. In design mode, they should have a yellow key next to them indicating they are unique and...

I do run the append query in code, but fitting the dot commands in the string was difficult. Here is the string that I tried, you don't have the tblObjects and you can get rid of the insert line, but it will give you the idea. There are no errors on the string, at least as far as quotes are...

I am, this function is part of an append query. The update button deletes all the records in the table and the query dumps everything in. Most of the info comes from the "MsysObjects" table, but I needed this function to get the description.

Hey vbaInet This is the code you helped me out with the other day. I was trying to fit this into an SQL string but the I gave up and decided to run it through a function. So here it is. Public Function GetObjDis(CN As String, DN As String) As String On Error Resume Next 'This function gets the...

Let me start by saying I got this thing to work by putting my function in a module, but I want the code behind a form. So the question is this: If a form is open and a function is public, shouldn't a query be able to reference that function? Must it be in a module? I have written a public...

You are correct, sorry, must have been tired last night. What I meant was that after typing the word properties followed by the dot, I got those four options. I did not look closely at your example to realize that I should just type in description; my apologies. And to clarify, I don't like...

Thanks for the suggestion, the properties gets me append, count, delete, and refresh and I need more. So I played around with your suggestion and, using documents, I think I have what I need. Try this in the immediate window on one of your databases...

AJR: You have given us a lot but you seem to be missing a table, the inventory. Somewhere on your form, you need the starting inventory number, perhaps with the combo box used to select the product. So with your example, user selects product A. The row source for that combo should be the...

I have created a query using the system objects table to populate a temporary table of all the objects in the database, which works great. My problem arises when I try to run this in an access project, the system table does not exist, and it won't let me have a table or query in a project. My...

Hilda, your issue is with table design. The staff table should have StaffID, FirstName, LastName. The Shift table should have ShiftID, ShiftName. Then in a third table called Work, you have WorkID, StaffID, ShiftID. This way work 1 done by person 1 worked shift 2 and work 2 done by person 1...

Thank you both for the input, all good options and the primary question was answered.