Search results for query: *

Andy - You are absolutely correct. That is what it says when I go into the debugger. I understand your questioning that. But that is what it says. Weird. I will run the Debug.print and see what pops out. Thanks!

Andrzejek (Andy) - Thanks for the response. Date range being used is 05/22/2016 thru 5/28/2016. Keep in mind if I hard code the dates into the query it will work. We usually use a week date range and I have used this for a month or even 2 month range. Thanks again MajP - I will give it a go...

Hello, Up until today this coding has been working perfectly. I am using it with MS Access 2010 in 2003 mode because that is how old the database is. The dates are pulled from a form that uses text boxes to enter dates. The text boxes are formatted to Short Date and they work great. The...

Thanks Diana! That worked!

Hi All, Any help will be appreciated. I want to add a field to a MS Access 2013 (Using 2007-2010 Settings) database. I want to add a True/False field. Field Name to be called DeleteRow. This is what I have. CurrentProject.Connection.Execute "ALTER TABLE BALBILL ADD COLUMN DeleteRow...

I had an MS Access database (2003) version running on XP. I have recently upgraded to Windows7 with MS Access 2010. There is some code used that was designed to populate a text field with the data located above, until it reached the next string of text. Here is the code as it was Public Sub...

Hello All. I am having an issue with getting a report in Access to generate in pdf. The only thing different from this report to other reports that I am able to do this with is that this report has sub reports within it. A while ago All my reports were generated in PDF then one day this...

I am building an query which refers to a table in another database using the IN clause, however the database is password protected.. do you know what would be the syntax in the IN clause to pass the password? SELECT * FROM tblName IN 'Address /pwd pssword' I get this a an error message...

I am trying to create a new label in a specific place on and MS Access form using VBA and I just can't seem to figure this out. Could be a bad day or I just don't have the knowledge. Probable don't have the knowledge. Any constructive help would be appreciated.

The answer to your Question MajP is yes I want an analog clock. I think it will look really good. Yes the Digital would be easy. MasterRacker - I just downloaded that app and I will give it a try. Thanks for the link. Will update once I know how it works and looks.

Anybody know how to create a clock face on a form or know where to get a module or an app that will work with Access? Your help is much appreciated.

I just wanted more than a yes or no. It isn't crucial or vital. Jut something to make the user be more careful which button they click. But we all know that will never happen. Thanks Guys!!

Would anybody know how to change the text of the buttons of a msgbox? I want a 2 choice set up. But I don't want just a yes or no. This is what I have now. Dim strPrompt As String, strStyle As String, strTitle As String Dim varPress As Variant Dim varPress1 As Variant strPrompt...

genomon, Thanks for the idea but it doesn't work. It only shows a certain amount of information then nothing...not even another page. If I could get it to print on multiple pages that would be great.

All, I am trying to size and OLEObject of Word Documents to print out in a Microsoft Access Report. The problem I am having is that all the documents are of different sizes and I will not know what is the largest size. How do I make the report as small as possible for each object printed? Any...

bjd4jc, That is PERFECT!!! Thanks So Much!!!!

bjd4jc, I have tried that but I keep getting an error message stating that the folder doesn't exist. I am sorry I have never modified shortcuts before..can you be a very specific. Here is the path to the database - \\NHHKSFS01\nhcqa\AuditAgingList\AuditAgingList.mdb And the path to the...

bjd4jc, I have tried that but I keep getting an error message stating that the folder doesn't exist. I am sorry I have never modified shortcuts before..can you be a very specific. Here is the path to the database - \\NHHKSFS01\nhcqa\AuditAgingList And the path to the MSACCESS.EXE C:\Program...

I have a MS Access Database on a network and want to limit access to one person at a time. The Exclusive feature on the Advanced Tab under options doesn't work. By going thru the Access program to start a database and selecting open exisiting file does work but I am looking for speed and ease...

I have some workflow data that gets exported to an Excel doc for the user to work off of. But what is happening is before an update can be generated stating these items have already been assigned somebody else selects work and gets work already assinged to somebody else and the database thinks...