Search results

Seecott, That did the trick. That seems odd to me because the value that makes up the criteria is clearly a number, it's an autonumber primary key! I was under the impression that "& Me.xxx" was strictly used for text values. Thanks though!

Thanks dkinley, I reversed the order...I guess the transitive property only works with mathematics! Anyway here is the new code: xTimer = DLookup("Timer", "tbl_ref_assignment", "AssignmentID = Me.AssignmentType") Now when the code executes I receive 2001 run time error, then it says "This...

This should be very easy but I'm goofing it up somewhere. I am performing a simple Dlookup on a table where the value of a combo box is compared to the primary key field. Dim xTimer As Boolean xTimer = DLookup("Timer", "tbl_ref_assignment", "Me.AssignmentType = AssignmentID") In this case...

Now you're talkin! I had attempted to do this using the query builder but clearly my structure was wrong because I received the error that I needed to select the table to delete from. I'll try this again using SQL directly and see what happens. Thanks Pat!

Pat, You are tenacious! I will answer your question in this manner. The dates in the child records are never the same. They may be the same date value, but they represent different types of dates. For example, in tbl_Dates, there is a Primary key, TaskID, datetype, and the date value fields...

LOL! In most cases that would be true, but in this case the dates determine if the parent record should be deleted. Perhaps this does come down to a design issue. I will have to see what that better design would be.

Pat, You are essentially correct, but this doesn't seem like a flaw in design so much as a backwards way of deleting records. For example, if a database is tracking orders and has a table representing customers, tbl_customers, and a table to track the orders, tbl_orders, you would expect...

I have the same problem that SSharma is having but with only one linked table. Understanding what Pat has said about deleting records on the one side, how can I construct this to delete the records on the one side and cascade to the many side when I need to specify criteria that is found on the...

I am having this same problem and I think this problem is caused by how my table is related. In my case I have a table (tbl_tasks) that is on the one side of a one-to-many relation ship with a data table (tbl_dates). Basically any given task can have multiple dates. Now when I try to create a...

Thanks guys. I think you have given me all I need to fix my problem.

You were correct pbaldy, this did work! Thank you. After looking at this though, I think there may be a more elegant solution. Since the pop up form I'm opening is record sourced from a query which has a field that matches the value I'm storing in the OpenArg value, using the WhereCondition...

I created a combo box with several name values. I want to capture the value selected using open arguments and then pass it (via open argument) to another form for display in another text box. This is essentially an, "Are you sure you want this value" form. I looks like open arguments are hard...

You could use the forms On Open event to check the field to see if it is greater than one day. For example: If you have a textbox called "txb_datecheck" which calculates how many days difference from the current date to the last date of the employee's vacation then your code might look...

gemma-the-husky, I did think of that as a possible solution. Initially my concern was to have this data present in both the datasource of the parent form as well as have a subform with this same data. Perhaps I should have designed my query for the main form in this way from the start to...

I can see that some description is in order. This main form tracks tasks and my problem is that users are creating open tasks with no due dates. Due dates are tracked in a related table, tblDates and viewed/added/modified through a subform. The query that is the recordset for the main form...

Judging by the text you gleaned for the On Current event (which I was aware of but was not sure if this would be the correct event) it appears that it runs before the next record is displayed. This sounds to me like it is referring to the original record which is what I am needing to check...

Does it fire after the new record is loaded or before the new record is loaded?

When a user changes from one record to another, I want to perform a check to see if the current record has a related record in another table. What event should I be trapping to execude the code?

I have this bizarre problem that seems to be affecting just one user out of six. For some reason when he views two reports (out of eight) he sees the textbox values but not the corresponding labels for them. All other users can see them fine. I checked his version of Access and it is the...

Problem solved through the code provided in this thread. :D