User Profile

Collapse

Profile Sidebar

Collapse
Wilkesy
Wilkesy
Last Activity: Sep 8 '06, 08:06 AM
Joined: Sep 7 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Wilkesy
    replied to Refresh Subform from Parameter Query
    Brilliant, thanks guys!!! i love this forum already!!!!!!
    See more | Go to post

    Leave a comment:


  • Wilkesy
    replied to Refresh Subform from Parameter Query
    Hi,

    Thanks for the reply, Where do i need to type that code?

    cheers

    Paul
    See more | Go to post

    Leave a comment:


  • Wilkesy
    started a topic Refresh Subform from Parameter Query

    Refresh Subform from Parameter Query

    Hi all,

    This is really begining to do my head in!!! I have a query that im trying to run, but i want it to refresh a subform, not open up into a new window.

    I have a CD database and so far i have my main form with an unbound box where the user can input the artist name, i then want the subform, which is all the required fields from the query, to be updated based on what the users inputs into the unbound box.
    ...
    See more | Go to post

  • Wilkesy
    replied to Help with Access/VBscript
    The Error message is

    Run-time error '3021';

    No current record

    Just a thought, would it be to do with the fact im opening the for in 'Add Mode'??

    Cheers
    See more | Go to post

    Leave a comment:


  • Wilkesy
    replied to Help with Access/VBscript
    Hi,
    Thanks for the quick reply. Ive tried removong that line before but i still get the same error.
    The theory behind using that line (Im by no way an expert) is that i want to undo the data ive just put into that field, and remove the record ive just tried to create, as im bringing back existing data from the table.

    Cant seem to get it to work, but its only happening when opening the form through the switchboard. ...
    See more | Go to post

    Leave a comment:


  • Wilkesy
    started a topic Help with Access/VBscript

    Help with Access/VBscript

    Hi All,

    Im trying to finish off some coursework im doing. Ive finished the database, created all my forms and everything works perfectly, that was until i created a switchboard!!!

    Im using the following code to notify users that when they enter an artist's name (im building a cd database) a message pops up and tells them the artist is already created and then takes them to the relevant record. It works perfectly if...
    See more | Go to post
No activity results to display
Show More
Working...