How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask ATLPROG Your Own Question
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

How do I tell MS Access, in a Macro, to scan records for a

Customer Question

Hello,How do I tell MS Access, in a Macro, to scan records for a certain value and take action on those values?
Submitted: 11 months ago.
Category: Programming
Expert:  Steve replied 11 months ago.

Hi there, my name is***** you do that in a Query, not a Macro. What exactly are you trying to do?

Customer: replied 11 months ago.
I am trying to tell access to set the same hyperlink for multiple records based on the value of a current form control.Once the initial hyperlink is set, I would like access to scan the table and set the same hyperlink in multiple records for the current temporary value chosen.The attachment is the macro I have created so far.
Customer: replied 11 months ago.
I think I need to create an if statement
Expert:  Steve replied 11 months ago.

Do you not want to do it through a button on the form? If you end up doing a macro, you should make it an Update query where you pass the value as a parameter. I'll look at it and tell you exactly what to do if I can see the database. Click here to do a secure upload of the Access database to my dropbox. I'm the only person who will see it and I'll delete it when we're done. If I can look at it I can help you a little better. You need to message me here and let me know you've uploaded it.

Customer: replied 11 months ago.
I can't upload the database due to company owned information. Could u explain an update query and parameters please, that's sounds like what I need.
Expert:  Steve replied 11 months ago.

An update query is a query where you replace data, for example, replacing a field in every record with the same hyperlink. The parameter is the hyperlink you're replacing it with.

Expert:  Steve replied 11 months ago.

Sorry, if I can't see the database then I really can't help you. We'll just go back and forth for a while and you'll get frustrated, and so will I. So I'm going to opt out and you can see if someone else will help you. Thanks and have a good night.