Recent content by Kieran

I need to be able to print out a report, but i also need to be able to specify how many copies to print out. i have a form with a text box which i was hoping to be able to enter the number in that box, then using a macro use that number for the quantity of prints. Is this possible??

Ok, just a quick question with i hope a quick and easy answer... I've only just started dabbling with web pages and Access... Now i'm just wondering if there is a command or something you can use in a web link that will start a new record. I have a single web page i want to using within a...

Well i got it working, but didn't really fix the problem, just went a long way around.... it was happening with different versions of Access... It seemed that my computer that i created it on was the only computer the date function was working on. i exported everything to a new blank database...

In my database, i use the "Date()" string for autodate fields and also just to display the date in one of my forms. i created the database on my computer and then i moved it to another computer and everywhere i used "Date()", it just says "#Name?" I put it on another two computers and the same...

I got it going now..... Thanks for the help, sorry for the stupid questions....

i got it working. i removed the input mask and it worked. I used the input mask just to add the "/" between the numbers automatically. Does anyone know an input mask that is query friendly??

Ok... The examples i gave were of the format i use to type the date in my form. I am using the similar syntax given by phil for my query criteria and when i try and run the query after filling out the form, that is when i get the error.... Now i use an input mask for the short date, could...

What Format?? Ok thats gotten me a bit further, but now i get an error saying "This expression is typed incorrectly, or it is too complex to be evaluated." Now i just want to make sure i'm typing the date in the correct format for the between operation to work. I'm using just a short date...

Start Date and End date from a table i want to be able to enter a start date and end date for a query in a form. I have been trying to do it by using a table to change the 2 dates i want to specify, then have the criteria of the query point back to the 2 date entries in my table. Between...

Please Someone Help!!! Please take a look and see if you have any help for me, i really want to get this going..... Thanks

Did it.... I used the GoToControl command and pointed it to the subform first. Thanks for the help, pointed me in the right direction.

macro is there anyway i can do it using a macro??

I have several subforms in my main form. I view each of these using option buttons and macros changing each subforms visible properties to show only the subform represented by that button. When i edit a record in one of the subforms then click an option button to go to another subform, this...

I have a form with a subform. I want to use a macro to go from a control in the main form to a control in the subform. I use GoToControl, but it just says that there is no field with that name. I wouldn't even mind if i could just set focus to the subform... Please help with some...

I use a database to store jobs i do. Sometimes i do more than one job for a customer. Is there a way to use a macro to copy the data from a previous record to a new record to save me re-entering it all?? Please help........ Kieran