Code:
[Forms]![frmTracer]![Return Date]<Date()
garymilam
Last Activity: Jul 22 '16, 10:34 PM
Joined: May 3 '16
Location:
-
If statement to run Message Box
I'm trying to run a message box of a if statement. On one form under the load event I want to put this code:with a "then" to open a message box if the date is not equal to current date. Help please. Thanks. -
NeoPa,
Thanks for the help. But I'm a novice at this, so can you tell me where to put this code, in the table or where? -
Format Autonumber
I need to format the auto number in my table to look like this: ABC-16-123. so letters, current year and autonumber. Can anybody help? Thanks -
Basically the check out date in my real dB is a destruction date. I would ultimately like to have that record archived somehow once there is a destruction date. as far as records, eventually there will be anywhere from 0-200 give or take. I really appreciate the help, I'm still kind of a novice at this, and can use all the help I can take. I really enjoy designing databases and want to learn all I can.Leave a comment:
-
update multiple records
I have attached my DB. I need to update all the records that have been selected for checkout with the checkout date from above. Somebody please help, I need this for my job. Thanks....Leave a comment:
-
update multiple records
I have a date closed field on a form. How do I make this field update multiple records. For example. I have books database. I have multiple books checked out with a date. I want to update the checkout date from my checkout form on multiple records which is a continuous form. Please help -
yeah just typos, I want the total of each color in each column and then I will add a total column for all colors, but once again, if there is a destroyed date, don't count it.Leave a comment:
-
Sample
Here is a sample of my DB.
[IMGNOTHUMB]https://bytes.com/attachments/attachment/8735d1464052378/query.jpg[/IMGNOTHUMB]
[IMGNOTHUMB]https://bytes.com/attachments/attachment/8736d1464052378/table.jpg[/IMGNOTHUMB]Leave a comment:
-
let me see if I can say this without getting in trouble...LOL. I have 3 different document sets. Green documents, blue document, and red documents. I want the query to count each color and return a total. But if a document has a destruction date, I don't want the query to count it. All the documents are represented by a checkbox. So for example if I have a document and it is red, I check the red box, if it is blue I check the blue box, ect... but...Leave a comment:
-
Aggregate functions
Ok, so I have query with the following criteria: Total Classes: Count(IIf([tblDocuments]![Red]+[tblDocuments]![blue]+[tblDocuments]![green]=Yes,1,Null)). This query has some proprietary info in it so I can't show the real words so I used colors. but anyway, I want it to count the number of classes, except when there is a closed date for the class, I don't want it to count the closed class. -
PhilOfWalton, could you try to send me the pics better, they are real fuzzy. I really want to use your send category you sent. Select a training and show who has taken it. Thanks for your help.Leave a comment:
-
Show Multiple Columns from ComboBox on Report
Ok, so I have a combo box that has addresses in it on my form. I have it so users can select the company name and show the full address on my report. Here is my code on the report =[Forms]![frmReceipt]![Combo91].[column](0). So 0 show the company name, but I want it to show column 1, 2, 3, 4 which reflects street address, city, state, zip. What do I put for columns 1-4. Help. Thanks.
[IMGnothumb]https://bytes.com/attachment.php? at... -
this is what I would want the form to look like. I'm just keeping track of different classes and dates in the list box.
[IMGnothumb]https://bytes.com/attachment.php? attachmentid=87 23[/IMGnothumb]Leave a comment:
-
ok so on a employee records form, I want to have a combo box that adds a class, a brief date and a debrief date. But I guess I would want to add one at a time. for example, one dropdown will have "one", "two", "three". add to list box column one. dropdown 2, brief date in column 2, and dropdown 3, debrief date.Leave a comment:
-
Combobox to fill Listbox
I know this is probably something simple, but somebody help me before I go crazy. I need make a combobox that populates my listbox with multiple columns. Please help. Thanks. -
Button to fill field for report
Ok, So I have a button to fill a field with "Y" and then when I click another button the field goes to the report so I can print it. The button was working at one time and then it stopped. didn't change anything, can anyone help.[IMGn...Code:Private Sub Command8_Click() If Me.fPrint = "" Then Me.fPrint = "Y" Else Me.fPrint = "" End If End Sub -
So I got it to open the word document, but its not filling in the form fields on the word document. Help anyone.Leave a comment:
-
Button to fill Word Document
I'm trying to create a button to fill a word document with information from access. here is my code, can someone tell me what I have done wrong? When I click the button it gives me an error on the Private Sub fillwordform() and Dim appword as word.applicatio n.
...Code:Private Sub Command170_Click() Call fillwordform End Sub Private Sub fillwordform() Dim appword As Word.Application Dim doc As Word.Document
-
Here is the SQL
...Code:SELECT tblEmployees.LastName, tblEmployees.Billet , tblEmployees.Program, tblEmployees.[Parent Company] FROM tblEmployees WHERE (( (tblEmployees.LastName) Like "*" & [Forms]![frmSearch]![LastName] & "*") AND ((tblEmployees.Billet) Like "*" & [Forms]![frmSearch]![Billet] & "*") AND ((tblEmployees.Program)Leave a comment:
-
Search Form
I have a search form with 4 search boxes on it. it searches a query that I have set up. The query has a criteria set on it of:Like "*" & Forms!SearchFor m!LastName & "*"and three other search criteria. The problem is that some search fields are not pulling every record. Can anybody help or suggest another way to do this. Thanks.
No activity results to display
Leave a comment: