Recent content by Beejay57

Use the label wizard in the reports design option It will run you through the steps to create a label format for the labels you want to print

have you by any chance recently installed or changed your anti virus s/ware i have norton on my machine and i got a similiar problem.To fix it all i had to do was turn script blocking off in the options setting of norton anti virus

i use a similiar thing as you with a couple of extra bits thrown in. i use a field in a table to set the date value each time the db is opened.I store the value as alpha numeric in one of the tables that holds similiar data.Unless the user knows about it it makes it that little bit harder for...

Not Really strong in sql but i think when building the sql you will need to use something like this strWHERE = strWHERE & "((h.HRID) = " & cboSurnameID & ")" and also when you have finished adding all your "And" then you will need a extra ";)" at the end...

It should be the same syntax me.TxtName="Steve"

try setting your control source back to the field that you want to store the data and set the controls default value to your dlookup. why do you need to store data that is stored in another table anyway ?

Have you preceded you calculation with = eg: =[baserate]*100

You may have more success if you save the form as a report and then print the report.You can then set the reports record source independent of what shows on the form.Usually when you print a form it prints whatever the forms record source is

It's amazing how many ways there are to skin a cat (apologies to the veggies)-Your not kidding!!! Thats why these forums are so good,there are so many different ways to do things in access. Anyway heres my last thought for this thread If you use the click event,and have your txt boxes locked,all...

use the on click event for the calender.This event is not listed in the controls events,it is only available in the forms code module. When in the code module select the calender from the list on the lhs,then select click from the rhs list

use the on click event for the calender.This event is available only in the forms code module me.Yourtxtboxname=me.Yourcalendername.value

You are only hiding controls on a form,not actually filtering the data Are you printing the form?

to add 30 records at a time rather defeats the purpose of using an access form for data entry.To add 30 records as you suggest would have to be done on an unbound form with 30 txt boxes and 30 labels etc.What happens if there are 31 records?.Then you would need to use VBA to save the 30...

no,if you want to create a new table you would use the make table query,an append query will only add new records to an existing table. to create a append query i first create a select query with all the fields and criteria that i need Then on the query menu bar you can change the query to an...

Use an append query.You can specify what records you want to append,what table to append to and what criteria is to be used