Search results

  1. C

    VBA Store Query result in Variable

    For now this is what I'm doing, in case others need to do this: I have created my own Private function to pass in a SQL string and receive a string value in return for the query. This will allow you to set a variable based on query: Dim varMyVar As String varMyVar = MyLookUp("SQL QUERY GOES...
  2. C

    VBA Store Query result in Variable

    I am trying to store the result of a query like the one below which is more than DLookUp will handle. Can someone tell me how to store the results of this query or like queries in a Variable? *I have been doing this by using a record set and just getting the first value the storing that...
  3. C

    Need to generate football fixtures database

    Are you using Access 2003 or 2007??
  4. C

    Need to generate football fixtures database

    Ok, that makes things much better. I will try to come up with a solution
  5. C

    Simple VBA help required please.

    alright, let me know if you need anything else
  6. C

    Simple VBA help required please.

    Send me what you got and I can help Please elaborate on what exactly what you are trying to do. This seems relatively easy but it is something someone would really have to look at to offer a solution. depends on how you have everything set up
  7. C

    forms

    You can probably just create a query that selects all three fields from the table and append a where clause to it. if you still need help give me details and I may be able to offer a better solution
  8. C

    Running a VBA Module from a Macro

    Create a Function in VBA consoleL: Public Function() ..... End Function Then go to macro and enter "RunCode" then browse to the function let me know how it goes
  9. C

    Update a field on a table

    May be a good idea to create a back up or do this on a copy of the database
  10. C

    Update a field on a table

    Ok, so this should point you in the correct direction if you create a Button and view properties, go to Event >> OnClick and Enter "CODE" Look through the following and paste it in: I warn you that I am less than 2 weeks into access and VBA but I am sure something like this can help you you...
  11. C

    Update a field on a table

    basically it seems like you are just trying to update information. I am assuming you either have a LOT of entries to update or this needs to be a repeated process. ??? One way to solve this issue is to create two record sets from the tables of interest with only the desired fields. what you...
  12. C

    Need to generate football fixtures database

    I am not exactly sure what you want. Pardon my ignorance but can you please define the objects you plan on using (exactly what a pitch is and how it should interact with everything else) example: Division consist of teams I'm lost on fixture and pitch (familiar with American Football) But...
Back
Top Bottom