Search results for query: *

Thank you jsteph! Thank you Ray! Thank you Duane! I tried a couple different solutions but in the end I found that using the DNS-less connection worked best for what I was trying to achieve. I just thru the code into a module and voila! It worked like a charm! Thanks again all for your help!

If you don't mind, can you explain how this code works? Is it creating a new table linked to the SQL Server database? And is this new table storing Authentication information? Also, does this only work for a single table or any table within the SQL Server database? Thanks again.

The tables were linked by creating an ODBC through File>Get External Data>Link Tables and by selecting ODBC for the file type. There is no Save Password box in the dialog that pops up when required to enter the Login ID and Password to the SQL Server. Any other ideas?

I have an Access db with linked tables from SQL server. There is password security on the SQL db. Everytime the Access db is closed the link to the SQL db is broken. Upon reopening Access I receive the message "ODBC--connection to 'SQL Server W01' failed." Is there a way to get around this issue...

The error occurs on: If DCount("Invoice_No", "tbl_FuelUsage", _ stLinkCriteria) > 0 Then Wouldn't I need to update this part of the code as well to include "Date_Purchased"? Already incorporated into the code is the line Me.Undo as can be seen below. This is the updated code in...

I had a default in on the date control. I removed it and re-entered an existing invoice number and date and received the same run-time error 2001: You canceled the previous operation. Any ideas?

Saved the form. Ran through it again and the code is not picking up the duplicate (No message box pops up).

Sorry, yes I tried it and received run-time error 2001: You canceled the previous operation.

Thanks for the reply dhookom. The control for the purchase date is called cboStartDate and the field in the table is called Date_Purchased. Should the following work if placed into the BeforeUpdate for Date Purchased? (Invoice number is entered into the form first then the date puurchased)...

I am trying to edit some code to prevent duplicate entries in a database based on two fields instead of just one. I would like to check the Fuel Usage table for records that match both the invoice number and date purchased. Any ideas on how to add the date purchased as criteria for duplicates in...

Oops, of course! Thank you PHV! How might I be able to alter this code to look up the value from two fields instead of just one to determine if the current entry would be a duplicate?

I am using the following code to check if the invoice being entered already exists within the db. I get the "compile error: User-defined type not defined" What is the solution to this eorror? Thanks in advance for your help! :) Dim SID As String Dim stLinkCriteria As String Dim rsc As...

Wow! That was surprisingly easy! Thanks so much ByteMyzer. Chew

Lol. Sorry I wasn't saying that Access is running in COBOL. I searched the FAQs but found nothing for emailing reports in Access. There was only something about emailing reports in COBOL.

I need a report to be automatically emailed after it is generated by a report generator. I'd like a command button that, when clicked opens a Microsoft Outlook email window with the report as an attachment. I have searched the FAQs for an answer but only found a solution for COBOL. Anyone have a...

Still looking into the problem but I find that the following works really well: Private Sub Form_Open(Cancel As Integer) Me.lblClock.Caption = Format(Now, "dddd, mmm d yyyy, hh:mm:ss") End Sub Private Sub Form_Timer() Me!lblClock.Caption = Format(Now, "dddd, mmm d yyyy, hh:mm:ss") End...

Thanks Missinglinq but I get the same result... although I do like the idea of displaying "Time" while the clock loads. MajP, I am looking into the questions you raised. Thanks again. Chew

MajP, I removed the Record Source from my form and the clock began to work. I need the Record Source in there. Is there a way around this?

I also tried the method here and got the same result: http://www.simply-access.com/AddingClockForm.html Microsoft ActiveX Data Object 2.1 Library is checked on. Any ideas?

MajP, I followed the directions in that link exactly and I'm receiving an error: The expression On Timer you entered as the event propoerty setting produced the following error: A problem occured while RPD was communicating with the OLE server or ActiveX Control. Am I missing an ActiveX...