Search results

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...

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...

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...

Some of my users have asked that I create a simple search form that will let them view several fields for each record and then select the desired record using record selectors along the left edge of the form. Once clicked, I will use the Form_Click event to display the same record on the main...

Hi all! Looking for some code help here. What I'm trying to do is change a value on all records once they are returned in a query. I have a yes/no field that I want to set to "yes" once the query returns the initial recordset. By changing this field to "yes" on all the records the idea is...

Here is the scenario. I am creating a database to track tasks. On the main table, tbl_tasks are the following fields: tbl_tasks *TaskID [autonumber] TaskName [Text] CreatedBy [Text] RequestedBy [Number] tbl_requestor *RequestorID [autonumber] FirstName [Text] LastName [Text]...

This seems fairly simple but I am doing this wrong. I am somewhat experienced in Excel VBA but perhaps because I am making the call from Access I am missing a step here. I have a number of files (usually 5 but the number may vary) that are saved in the .CSV format. I want to open these and...

I am trying to avoid using the DLOOKUP function due to the impacts it has on performance (load times). This is especially prevalent on a not-so-fast-network connection. I have a form based off a query that itself is sourced from a table of work orders. There is another table that houses...

I am trying to avoid the creation of a lookup table where I know I should be able to calculate this. I need to determine the start and end date of a week number. I did find this post from 2002: http://www.access-programmers.co.uk/forums/showthread.php?t=33116&highlight=start+end+dates+week but...

I have a main table used to track project details. Related to this table is a table called, "tbl_dates" which houses all project dates. The dates table looks like this: DateID | DateRefID | DateEntered | WorkOrderID These four fields store Field 1 - (PK) DateID: which is an Auto-number for...

This problem has been brought up before and solved in a number of ways. I have been working on a module to do this...but in my own unique way. Here is the grist of it. I am trying to setup several textboxes with "target dates" that will give me the next business date (Mon - Fri). The...

There have been a number of posts that are similar, but not quite what I have been looking for. Most only check to see if the target date is a weekend or holiday, but I am looking to "skip/not count" any holiday or weekend day that occurs within the period of time. For example: If given a...

I have a table that contains all the contacts for a project. This table consists of 5 fields. | ContactID | ContactType | First Name | Last Name | Workorder# |. There is one particular record that must be created for each work order before it can be saved. That is a record where...

I have a table called tbl_workorders. One of the fields on this table is optional but because the lookup table is on the one side of a 1-to-many relationship using an auto-number key it is requiring that this field be populated to create a record on the workorder table. This is a problem...

I have two subforms that are sourced from the same query. One is in continuous form view and is used to select values, the second is in datasheet view and shows all the values that have been selected (multiple rows here). My goal is that the user will use the first form to make selections and...

Thanks to all who have provided help on other threads. I have made some progress but I am still struggling with the last couple of relationships here. I am tracking projects and have normalized this data into the following tables: tbl_customers (contains customer specific information) Is...

I have been asked to redesign a database that tracks a huge number of data points. These are projects and the original table had over 100 fields. I have managed to separate them to related tables in an attempt at normalization. They are: tbl_workorders (main project info) tbl_services...

I've searched through many posts here and read many off forum as well. The more I read, the more I am getting confused as to which method would work best. Setup: I have a table for work orders called tbl_workorders. This table has a many to one relationship to the table of customers. The...

This is so simple but I can't seem to make it work. I've poured through about 30 posts and tried all kinds of AfterUpdate event strings to no avail. Help! Here is the simple setup. I have one table that lists employees and their corresponding teamleader. A grouped query provides the...