Recent content by connordrew

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...

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 =...

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

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...

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

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...

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...

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

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...

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 :)

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...

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...

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

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...

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...