Search results

  1. C

    MS Viusal Basic 6.0 with MS Access

    Hi Elric What have you created so far? Do you have the access database and the tables created in access? Do you have the access database and the tables displayed in a form in VB? The best way for VB6 to talk to access is via ADO (Activex Data Objects) Give me as much info as you can and i'll...
  2. C

    Visible Image if 2 checkboxes are true

    Thanx Ken, Worked perfect. Also, I successfully managed to modify it a bit so that if logged = yes and either wma or mp3 = yes, then the play button would be visible. Private Sub Form_Current() If Me.Logged = True And Me.WMA Or Me.MP3 = True Then Me.PLay.Visible = True Else Me.PLay.Visible =...
  3. C

    Visible Image if 2 checkboxes are true

    Thanx Ken, I will give thata try and let u know how I geton.
  4. C

    Visible Image if 2 checkboxes are true

    Hi, I have three checkboxes on my form and I would like to set the following properties: I have an MP3, a WMA and Logged field. If logged = yes and either wma or mpr = yes, then I want a play button to be visible. I have tried using the following code: Private Sub Form_Current() If...
  5. C

    Holding down Shift

    i'd like to see acopy of that Roy. Could u post it m8? Cheers
  6. C

    Forms Sub forms and a Enter button

    Mike, Thannx and happy to be of help. One thing you will learn through time on this forum, is the great help you get from others. I have learned a lot myself through this particular forum over the last 18 months. Anyway m8. That part of the code, is an error handler. For example, if you...
  7. C

    Forms Sub forms and a Enter button

    Hi there Mike, Good questions you asked there m8 about PK and Autonumber etc. In my own defence :) I had just spent about 20 odd hours on my database and probably I was tired when I created the database yesterday. However, on a positive note, I have modified your database which I am sure will...
  8. C

    Open Form on Menu then close old form

    The button you are clicking to open the new form. place the following code in the on click event. Private Sub yourbutton_Click() DoCmd.Close DoCmd.OpenForm "yourformname" End Sub hope that helps
  9. C

    login form which restrict the access

    A quick way round that would be to create a copy of your form that the admin has access to and call the form guest. When you open the guest form, highlight all editable controls and choose properties and then choose yes in the locked tab. Please also Remember to direct your guest users to your...
  10. C

    Forms Sub forms and a Enter button

    Hi Mike, You forgot to post your database. However, here's something I created and I hope you can get the idea from that. Hope that helps :)
  11. C

    Copying the style of a form from one database to another?

    Create a new database and save it on your desktop and call it newcopy. Then goto file+get external data+import and locate the copy of your old database and import the various forms and any otehr information like tables or queries and click ok. This will allow you to import from your old...
  12. C

    Can Anyone Help?

    now that would be very interesting!!!! All my music files will be .MP3 and .WMA. I will be indexing them all soon and I like the way you have created the field so that as soon as u select an artist, the song plays. I had my original field as a hyperlink, but I notice yours isn't. Is there a...
  13. C

    Can Anyone Help?

    hi Dave And thanx for your reply. Excellent Dave, I am sure I can incorporate that into the database. Thanx again
  14. C

    Can Anyone Help?

    Hi there, I want to index my music in a database and I have created three fields database as follows: ID (AutoNumber) Primary Key Log (Yes/No) Play (Hyperlink) I would like when I click the Log button on a form, the play field automatically names the field like this: c:\music\1.mp3...
  15. C

    Tables For Car Showroom Database

    I am constructing a database for a local car sales company and I would like to have the tables set so that if the user selects Vauxhall from a drop down menu, then all the Vauhall Models would appear in the model column. Equally, if they choose ford from the manufacturers column, then all the...
  16. C

    Creating A Search Button

    Hi, I would like to have a search field on a form that looks for data within a table. For example, I have field A and field b within the table. When someone searches for data within field a, both field a and field b data etc would be displayed. Any help would be greatly appreciated.
  17. C

    Let's see some other people's designs?

    Thanx Mile, I have looked at the samples in the sample database section. I just thought it would be nice for other people to submit theirs. thanx
  18. C

    Let's see some other people's designs?

    Hi there, I am fairly new to access and I would like to see some screenshots of other Access users' designs. Just so that I can get an idea of what you can create in a basic - advanced level. The attached file is simply an exit form. By choosing Yes, Access closes down and by choosing No...
  19. C

    Welcome Message?

    I have created a form which I want to use as a welcome message. It is simply called form 1 and if the database is opened, I want form1 to be displayed for about 10seconds. Thanx
  20. C

    An automatic time + 30mins

    one problem guys, I have made the form direct from the table data rather than from a query. Where would I type: =IIf(IsNull([txtStartTime]), "-", DateAdd("n", 30, [txtStartTime])) many thanx
Back
Top Bottom