i need nelp running a macro

[rotexy]

i am using a ms access for the first time and i want to run a macro that will help me search for record in table how do i do this

 

[Hayley Baxter]

If you want to use a macro for this you can use the Find Record Action that will match whatever search criteria you specify in the action arguments. It will look for the record on a form, your form will be based off either a table or a query and you can run the macro from the form via a command button.

This probably isn't the best way to search for a record, it really depends what the use of your search is but you may be better just to create a search form instead. For example your macro will look for the same search criteria everytime where a form will give you the option of changing your search criteria.

 

[rotexy]

okay?

how do i create a search form then remember this is my first time of using access

 

[Hayley Baxter]

There are a number of ways to perform searches. Have a look at this sample than DES kindly put together. This may help you decide what form of search best suits your requirements.

Hay

 

[rotexy]

that is exactly what i did but it showed me a dialog box saying there is and error somewere in the macro and i cant figure out where the problem is

 

[Hayley Baxter]

What is the error message you are getting or can you maybe post up a sample db?

 

[rotexy]

hey

hey do u want to see a copy of my database and try to figure out what the pronlem is. ans how am i going to attach the stuff. can u gimme ur e-mail so i can send the database to u by e-mail

 

[Hayley Baxter]

Can you post a copy of your database here on the forum? Just zip your db and select the manage attachments button and it will allow you to browse for your file. If you are having problems uploading your db, my email address is in my profile.

 

[rotexy]

hey

i think i have uploaded the database please help me figure out what the problem is

 

[Hayley Baxter]

i think i have uploaded the database please help me figure out what the problem is

Where? No file attached on here and I have not received anything via email from yourself. As I don't know what messages you are receiving it is difficult to identify what the problem is.

You can however single step through a macro and identify the problems. There is a section in MS Access help that covers this:

I have taken the below from Access help so you can give it a go.

Open the macro.
How?

Click Single Step on the toolbar.


Click Run on the toolbar.


Click Step to carry out the action shown in the Macro Single Step dialog box.


Click Halt to stop the macro and close the dialog box.


Click Continue to turn off single stepping and run the remainder of the macro.
Tip To halt a macro while it's running and then single step through it, press CTRL+BREAK.

Hay

 

[rotexy]

okay

i will send the stuff to you email. my address is roteemee@hotmail.com