Search results

CallDate is in general format and the form fields are in short

the calltype is in general format. the form fields are in Short format

It is still giving me a datatype mismatch

nevermind I see it

so how would that work in this IntC = DCount("[CallType]", "dbo_tbl_DailyCall_Log", "[CallType] = 'Inbound' AND DateValue([CallDate]) Between Forms!Retriever![txtDate]AND Forms!Retriever![txtEndDate]") thanks Nick

the date function does not seem to work in the dlookup.

I have a Dlookup below: IntC = DCount("[CallType]", "dbo_tbl_DailyCall_Log", "[CallType] = 'Inbound'AND [CallDate] >= Forms!Retriever![txtDate]AND [CallDate]<= Forms!Retriever![txtEndDate]") txtDate and txtEndDate is a date in this format: 1/26/2005 unfortunatly [CallType] is a date in this...

I Have a form that allows a user to update a password. Each time a password it is updated the current date is recorded. Each password expires 90 days following an update. On the form I have a "Last Updated textbox" and an "Expires in" textbox. What I would like to happen is that when a password...

I am sending an email from access that outputs CUSTOMER SYSTEMS DEPARTMENT WAREHOUSE REQUEST FORM ------------------------------------------------- Requested by: Nick ------------------------------------------------- Date Requested: 01/05/2005 Date Needed: 01/08/2005...

That option works fine until you try and open an excel file by double clicking on it icon. When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel, instructing it to open the workbook that you double-clicked. If the Ignore other...

I have an access database that uses a link to an excel spreadsheet. Unfortunatly it does not work if there is someone editing the file. I am only reading the file, not writing to it. how can I link to the excel file when I don't have editing rights. thanks in advance Nick

I have two combo boxes that are connected to a popup calender. These combo boxes are named Install date and Prep date. I would like to have a function that would check if the dates entered were at least 5 days apart. Thanks Nick

I have a question. On a day-to-day basis our department schedules appointments using Microsoft outlook. I would like to use access to connect to outlook and download the dates and times of those appointments into access. Is there a way to do this? Thanks in advance Nick

The text file stores account numbers, so it could potentially hold 1-10 5 digit strings.

I want to open a txt file and place the contents of that textfile into c aombo box. I am having some trouble because there is not an additem method. Here is my code so far. Private Sub AdditionalAccounts_GotFocus() Const ForReading = 1, ForWriting = 2, ForAppending = 3 Dim Item As String...

here is my problem. I have a form that contains client account information. The primary key is AccountNum. It is required that some accounts will have multiple secondary accounts. here is my thought process Add additional account number -----> which is stored in a text file additional...

I have a text box and next to the text box is a button. I would like to add an account number ie 9586 into the text box and click the button and have that account number added to a new or existing text file on my hard drive. I would also like to populate a combo box based on the text file. I...

worked.. Thanks

My problem is determining the winning combinations. I have the picture animation already functional. Ok my program outputs three numbers, lets say 342, There is a list of numbers and this list determins if the output numbers is a winner. sample list 334 314 346 456 342 So the program...

I have 3 variables randomNumber1 =4 randomNumber2 =3 randomNumber3 =1 How can I take those three variables and place then into a variable that looks like this... AllThreeVariables = 431 thanks in advance