Search results

how can I tell what line it errors out on?

I have attached two documents, the word document is an error I am getting, and the txt file is the code behind the button, could someone point me to the right direction for a fix. Thanks

I guess i have another question. For the dates, how do i use the parameters that i use. I am not always going to run this report for just February.

I didnt see your PS on the bottom I got it. THanks alot!!!

=datediff(d,[Enter a Start Date],[Enter an Ending Date]) Thats what i tried using. But i got an error, and it prompted me for another parameter. The dates in Brackets are my parameters that i use when the report is being run.

When a desired user is running a report they get 2 pop up boxes for a date range. Is there a way to figure out how many days are in that range. example if they put 2-1-09 and 2-28-09 thats 28 days. I want a seperate Txt box to display the total days. So for this month my textbox would...

I currently have a access 2000 database thats on a server and have two users access it at the same time. There is a set of 4 import buttons, where they import some collections information in from an accounting system. Behind each button theres approx. 8-10 queries and some other code. Does...

I have taken over a database from a previous employee and he has a section built in to back up tables, but its not functional yet. Basically all it is, is a button with no code behind it. I would like to implement that, could someone give me some advice and some code on how to back up tables...

It works, Thanks!

Thanks i got my 2nd question working. I dont see a help on my format property of the textbox? or where should I look? Also i dont get what you mean 4 parts, and one is a zero?????

Ok, on my 2nd question: WOuld i jsut add another textbox or what would i do, i cant get it to work?

I have 2 questions, that im sure are simple to someone on here, but i can not get them to work. 1. I have a report where sometimes the values are zeros, is there a way just to hide the value if its a zero? some reports have alot of zeros. 2. I have a Footer called TruckNum Footer, in the...

We have a network print server and often in the que of all the printers it will say "Unable to connect" and i will go reset the server and it goes away for awhile and then will appear again. Sometimes say last week it rarely did this, but so far this week i have reset that server alomst 20 times...

I have serveral reports where in the query for the report i have for example Between [Enter a Start Date] And [Enter an Ending Date] Is there a way to get what ever dates they type in the pop up box onto a report? if so let me know. Also i have some reports that when they are run they have a...

In access 2007 In the report design view, all my column heads seem to be locked together. this makes it kind of hard to format at times, is there a way to unlock these? Thank.

Sorry i got this figured out. I forgot to post back. Thanks for all the help.

I have it set up the way i think it should be, but in a textbox i cant figure out how to bound it to a field like the combobox. there isnt that option wiht a textbox. All i see is the control source, and i did that and it dint work.

So like this? Between [Forms]![frmLocation].[textbox1] and [Forms]![frmLocation].[textbox2]??

I got that to work, thanks. How would i put the criteria in the querey for the begining date and ending date, so that i can use textboxes on the form? right now in my querey i have Between [Beginning Date] and [Ending date] so my question is how would i use that in a criteria with 2 text...

so after you changed it to 2, whatwere the steps you did? have the form open and run the report? what was the criteria for that field in the querey?