Search results

Hello all, I've got a report thats made up of 4 fields. One of the field is a tick box. When i view the report its fine, and when I export to snapshot format its also fine. When I export to excel the tick box field doesnt export. Help !!! Stu

Thanks Pat. I've actually got the record field called active in the same table as all the other fields. Its called main_table. For this to work do I need to create a new table and create a relationship with the courier number and active field ? Stu

Hello all, I've got a form which has a field called courier_number. When data is entered in the field I want to query a yes/no field called active. If its no then display an alert message. If its yes then do nothing. Help !!!

Cracked it thanks. Problem was that I was dragging fields into the query that could not be grouped in line with the counts of the others. Funny how just typing it here helps clear your mind :D

Actually just had a revelation. If I just have 2 fields in the query... Courier_no in twice. In the total field I've got one with group by and the other with count it works and I get the results I want. Problem I then have is that I want to add other field to the query but when I drag them in...

Hello everyone, Got another problem that I'm sure you guys will solve with your eyes closed ;) I've got a database with a field called courier_no. Imagine this set of data. 1234 1234 1266 1277 1277 1288 1299 I want to run a query to count the number of instances that each number appears...

Thats cracked it and its the first time I've added any VBA code to a database :D Thanks for your help.

Ok must be a bit thick guys so bear with me. I've logged on this evening to give your suggestions a try. If I enter CC In = True I get an error that the macro cant be found If I enter =CC In = True I get an error that the operation requires perinthesis If I enter =[CC In] = True I dont get...

Brilliant advice folks. I'll try when I get to work tomorrow Stu

Thanks - I was putting in yes instead of true !!! What does the .value bit do after the field name ? Stu

Hello all, I've got a form with a field called courier comment. At the moment users enter a comment in this box and then put a tick in another field called cc in to confirm that they have entered the comment. Its not working very well as users are putting comments in and forgetting the tick so...

I've got a simple form operating on a database with a duplicate record button at the bottom. When the butten is clicked I want to create a new record with only some of the fields carried forward from the previous record. Duplicate function copies all fields. Is there a way to do this ? Stu