Search results

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

thanks yeah i thought thats what it was, i just wasn't sure and was just wondering for peace of mind.........thanks for the help. i realise about deleted records though....he he regards, Kieran

I have an autonumber field in one of my tables. It is the primary key. I've been finding that it skips numbers every now and then. Is there any reason for this? Or any way of fixing this?? Thanks Kieran

thanks thanks for the help, i have now fixed the problem......,

refresh?? so do u mean in the macro set 'runcode' to 'refresh' ?? or is it a seperate macro command??

i need a command for a macro that will save the record i'm working on from a form. i have an older database which has this code =rECsAVE() but i tried it and it doesn't work. if any one knows any command for access xp that will save a record from a macro please help me........... regards...