Search results

The data type is short text. Thank you :).

I am trying to add a calculated Textbox to a form for DueDate The below formula gives a #Type! error Control Source Formula in DueDate: Using the name of the textbox =IIf(IsNull([Text1186]+21),0,([Text1186]+21)) Using the control source =IIf(IsNull([RecieveDate]+21),0,([RecieveDate]+21))...

The database was designed in access 2003 so I updated it to the newer version and everything works great. Thank you for all your help :).

I get this error in access 2013 on the field in the table Invalid SQL syntax - can not use multiple columns in a column- level check restraint. Expression [Kit] Thank you :).

The below is the format of my table. tblReagent Kit Lot RecieveDate QCDate InuseDate ExpirationDate Current Type If I create an update query for type and set the updateto to [Kit] and run it manually the table updates. Is there a way to run the query after the user updates Kit in the...

I will post the db tomorrow, but the table structure is. TblName Kit Lot Recdate QCdate Usedate Expdate Current Type Basically, when the user selects kit that same selection appears in Type as well. The form that is populated with these values works great using your suggestion. For...

Very helpful.... thank you. On the lookup table which is nothing more then the below: Kit Lot Type I have it setup to where kit is a dropdown of defined values. Is there a way to have "Kit and Type" linked, so that when the user selects the "Kit", "Type" is changed/updated to that same...

So basically what I am trying to do is create 1 table with multiple reagents in it and have a field on that table that distinguishes each. Then in a form have that lookup table be used to populate the form. Like you have in your example. Using your example if Type=1 the code works great...

I am creating a lookup on a form that will pull a value only if a column (Inuse) is true. Is it better to have seperate tables for each condition (say 1 and 2) or 1 table with conditions (1 and 2) in it? If one table is preferred does the below look correct? Thank you :). Separate...

I am having trouble modifying the below code to export the select records by Month: VB Private Sub Command33_Click() DoCmd.OpenReport "HLA TAT", , , "Len(Month & '') > 0 AND [Receive_Date] > #" & Forms![HLA TAT].Month & "#" End Sub As of right now when the user clicks on the export button, a...

I am getting Microsoft access cannot find the referenced the form HLA_TAT I have modified the code to the below and am trying to have the user select the month from the dropdown and click the export button to have all records matching that month exported to excel. Private Sub...

The export button is within the HLA_TAT form. Thank you.

I don't see anything that is applicable unless I am missing something. Thanks :).

I am trying to export records to excel that are in a given month based on an input month. The user would select the month with the records desired and click the button to export them to excel. The attached zip file has an image of the database and the code behind the button is: Private Sub...

I get, The select statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect. Also, how to a format the button on the form to include the [What Month] user prompt? Thank you :) Public Sub ExportQuery1ToExcel() Const FILE_PATH As String...

TAT Query: SELECT [HLA TAT].[HLA ID], [HLA TAT].[Last Name], [HLA TAT].[First Name], [HLA TAT].[Date Received] FROM [HLA TAT] WHERE ((([HLA TAT].[HLA ID])=[Date Received]) AND (([HLA TAT].[Date Received])=[WhatMonth])); I'm not sure how to use this in export button on frmSample. Thanks.

Below is the TAT SQL: SELECT [HLA TAT].[HLA ID], [HLA TAT].[Last Name], [HLA TAT].[First Name], [HLA TAT].[Date Received] FROM [HLA TAT] WHERE ((([HLA TAT].[HLA ID])=[Date Received])); Thanks.

Public Sub ExportQuery1ToExcel() Const FILE_PATH As String = "C:\Users\cmccabe\Desktop\" Dim FullPath As String strFullPath = FILE_PATH DoCmd.TransferSpreadsheet acExport, , "TAT Query", strFullPath & "TAT.xlsx", False MsgBox ("Export is complete.") End Sub Is this correct and how...

I am trying to create a button on an access form that will prompt the user to enter a search month and then export to excel all records in that database that match that month. So, if the user prompt "what month" is October, then THE 30 records in the field [receivedate] that are in october...

Ok, the data table is now a linked table in access. Thank you.