Search results

That is strange. If you are entering the date in the text box on your form in the same format that it is within the underlying table you should be pulling data. Silly question but is there data for that particular date in the underlying table? Try putting double quotes around the date in the...

I am a little confused. What is the date format in the table the query is running off of?

Hey Wilse, I would go to your query and in the "where criteria" right click. click build > Forms > loaded forms > select your form > select your monthtext text box and hit ok. Once you change the date on the actual form text box it should relate to the underlying query.

Good Afternoon, I have two make table queries in which I would like to control from a form. What I am trying to do is have a form with mulitple text boxes on it: Tax id, Symbol, CUSIP, Account. I need to have four text boxes on a form that relate to a query. Not all of the text boxes...

Thank you for your help SOS. I was not clear with my set-up. I currently have the "main" front end and back end on the share drive which I use to when updates are needed. Each Associate has their own copy on their desktop. SOS - Your second option worked. The copy has to be on the persons...

Lagbolt, Thank you for the suggestions but it did not help. To make sure I understand correctly. For method one. I went into my 2007 code window and changed the priority of a couple of my references, then I went and checked the database on an associates pc with 2003. No luck. For...

Good Afternoon, I have a unique situation, however I think it is a relatively easy fix. I created a text box on a form me.base_date that displays the date when you open the database. At the time of creation I had access 2003. I have since upgraded to 2007 and made some changes to the...

This worked Perfect! Thanks Again!

Great!!! I will try it. Thank you pbaldy.

hmmm.....I am a little confused how to get this started. Could you give me any other tips? Thanks a bunch!

Hello All- I am creating a call log database and need help with some of the logic. When the supervisor clicks the submit button for a particular call for one of their associates I need to check what month we are in and then find how many calls have been submitted for that month. (I have a...

WOW...I learn something everyday! Great Tip!!! Cheers.

Hey Bob. You lost me on step two. Where do I place the "Tag"? I am unfamiliar with that term. Thanks for all of your help.

Good Afternoon all, I think I have an easy one here but I am unable to get anything to work. I am trying to creat a form that when it opens, if it is not the supervisors certain buttons are not visible. Please see my code below. Sford is me and I can not get the buttons to show when I...

You are the man!!! Thanks BOB!

Hello- I am a bit confused regarding the below code. I am working with another department within my company and they have been caring enough to share code that will import a text file into an access table. I am importing the same exact text file that they are as well trying to import into the...

Hey Guys, I have a form with a bunch of text boxes on it. I would like the "title/lablel" of the text box to appear within the actual box and then disapear when an associate enters information. I have tried the default value in properties but have not had any luck. Has anyone done this...

AWESOME! This helped me out as well!!! Thanks misunders2d!

Hi Guys, A while ago I had followed missinglinq's advice and downloaded the "Auto Format" code. I am having some issues with it where it does not always auto format. I am about to go live with a DB within my department and with my luck the auto-size module/function decided to stop working...

Pyro, I am trying to get my report to open in PDF format. I tried using your code above, but did not know what to put when I got to you ["Output file name"]. All I want to do is have the report open in PDF Format so that the associate can print it off. I suppose they can do this with the...