Search results

I have a Database in which I set all the Min/Max Buttons Property = "None" on all the forms, and I set the Close Button Property = "No" on all my forms. Everything is working just fine. Except off a few of the forms when I open up reports, it also turns off the Min/Max Buttons and turns off...

A user asked me if they can use the wildcard characters when they filter a form on a Date Field. The user is right clicking in the field, then next to "Filter For" they are typing in "12/##/2002" to find all the records from Dec. 2002. When they hit Enter, an error message pops up and says...

I have a text box with the Can Grow property set to YES. The Report Section's Can Grow property is also set to YES. When the text box's Record Source = a field named [CompanyName] the text box grows just fine. When I set up the text box so that the Record Source = "Company Name = " &...

I have a query that is pulling in a date field [Order Date](yy/mm/dddd) and I want to find all the records where the date field = yesterday (so if today is 12/9/2002 I want all the records where the [Order Date] = 12/8/2002). I was trying to figure out a function to do this and decided to go a...

My users want to run a query that pulls in all the records from a table where the Create_Date field (Date Type mm/dd/yyyy) is from the previous Friday through the Current Date. So if it is Wednesday, the users want all the data from the previous Friday - Wednesday. The tricky part is, if it is...

I have a query that uses an Input Box to get an input value from the user. The Input Box asks for a set of initials [Like "*" & [What is the initials, leave blank for All] & "*"]. If the user enters in the initials the Input Box works correctly. But I am trying to take this to the next level...

Is there anyway to enlarge, bold, or change the font of a standard MS Access tab control page headers. When I add the tab control to a form, it defaults the font at Tahoma Size 8. On the properties I could not find an option to change the font size, type and weight. If anyone has any ideas...

This one shouldn't be that tough, but I have not found an answer yet. I am building a query in code on an MS Access 1997 DB. The query runs correctly and everything returns correctly, all the query does is select 2 fields from a table where field 1 is equal to a certain value. The problem is...

This one is off the wall, but I decided to give it a shot and ask anyway. I have a user who wants to preview their reports in print preview mode, and then when they print the report they want the ability to hide certain fields and labels (same fields and labels for each record through out the...

I have a report that is fairly complecated, the report is based off of a Cross Tab Query, and has 3 subreports on the report with their information based off of a Cross Tab Query. Normally this report works fine when 1 - 3 pages is the length. The users then tried to run this report with...

Thank you very much, worked perfectly.

This shouldnt' be as tough as I am making it out to be for myself, so I decided to come here to ask. I have a simple report, based off of a table, and I have the Text Boxes Can Shrink and Can Grow Properties = Yes. I want to hide the Labels of all the Text Boxes where the Can Shrink property...

Thank you so very much for all your help, it is greatly appreciated by me and I am sure I will get it to work, I just need some ideas. I never considered DateDiff to start with, so this will send me in the correct direction. Thank you again, T.J.

I have a Field to store the Age of an individual. The user wants this Age Field to autocalculate from a Date Of Birth Field also stored in the table. I was trying to think of a way to subtract the DOB field from the Date() function as the Default value of the Age Field. I could not find a way...

Thank you very much I will give it a shot T.J.

This is a little tricky, I am using a the MS Access Find and Replace function on a form, so that once a user clicks a buttong, the Find And Replace pop-up dialog opens and tries to Find or Replace the field that was set to the focus when the button was clicked. Here is the code I am using...

Thank you so much time for your attention to this subject. All I can say is this is a WEIRD deal. I am an access programmer and I have to break VBA code all the time. I am unaware of anyway to turn off the F9 (break code function) so I am not sure how to turn of off, or even back on, but that...

Thank you again, yes i did get the "hello" message that I marked as a code break (F9). Nothing will code break. The code is working just fine, just will not break. There has to be an option some where in the database. I have compacted and repaired, and tried after ward, still nothing. But...

thank you for responding, yes I have tried that as well, none of the code will break at all. I put a message box "hello" on a two different forms on their open, and a few other procedures and it did not break at all.

I cannot figure something out this simple and it is driving me crazy. I set up a code break in my VBA code (F9) and the code does not break any where. I know that some how the code break option has been turned off. I checked under Tools and Options on both the database and the code, and...