Search results

Such a dumbo !! I put [form]![xxxxx]![xxxx] instead of [formS]![xxxxx]![xxxx]

Stupid and simple answer I'm sure. I have a Form where I select selects and Employee no, then a button with code opens another form and appends a new record. This works fine. Then I am trying to edit data in the other form (like put a new date in) using code in the original form but it wont...

Dear Beetle You are a star !! Many thanks working like a dream now :D:D

is there a simple loop that will allow me to run through all records in a form and perform an action on each record, then move on to the next ? how do I stop at the end ??

maybe i wasn't clear but i want to email a customised report to a number of customers - only containing their data

I want to hard encode it - rather than allow the user to choose.

Hi Guys and Girls, I want to send a report to an email but I wan to do it for selected customer I'm gunna use the SendObject to send the mail but I need to pass the data to the Report to just select to required customer so to open the report I want to have something like:- Dim CustomerName as...

Thanks for the Report bit, but how do I customise the email addresses:confused:

Hi Guys, I want to send a stock report to a number of customers. But I dont want loads of reports and queries. Is there a simple way I can define the "send to" email addresses and then use the same report for each customer with a variable in the query to select the relevant data. I am...

Thank Steve - I did think of creating a table with the exact no of labels needed but that solution is so simple and elegant:D Thanks

anyone know a simple way to print a variable number of labels based on a filed in the record - ie field is 60 I need 60 labels. Ideally with an incrementing counter no on each. thanks in advance - Adrian:confused:

Does anyone know the syntax for a loop that steps through every record in a table For 1 to x (where x in the no of records in the table) action next how do I set X to be the number of records in the table???

i got it to put in random numbers into the table using 1 to 5 loop but dont know how to do it when i dont know how many records i have i need a loop that starts at record 1 then stops at the last record without adding new records its really the looping bit that i'm stuck with not the random...

Thank you, but how do I do that ? Public function ??? I know how to do an update Query, but what's the syntax for the query ??

I want to randomly select a number of records from my dataset - (to perform random Stock Checking) Say 50 records each time - but randomly I thought about putting a random number in each record and then selecting top top 50 records after sorting in order by the random number. Q:- how do I...

i've just updated to access 2007 and been having trouble with parts of my system not working. is there a way to sort out the trusted database so that everything works. Turn it off would be best. my network is behind a firewall

the code is in the query . . . as a selection. A want to use the value on the current form to select in the query

I need to print a particular selected record from a form which contains a list. The query has the correct field, but I cant remember the syntax. I think is something like "me.forms!me.Fileld1". can anyone help and put me put my misery . . . thanks

I want to take a report which covers sales figures and e-mail to those people that have had sales in the period. I only want each person to get just their records, not the whole report. Any ideas how I can do it automatically, starting with a query of records or a report ? ? I know how mto...

I need to Print a single record from a form but using a report layout. I have created the form and created a report. A button on the Form kciks off the print but I get all records rather than just the one shown on the Form. Whats a really simple way of just selecting the Current record...