Search results

I am looking for a little bit of advice for tracking my mp3 collection. so far I have set up the following tables in my database tblArtists ArtistID PK ArtistName tblTracks TrackID PK TrackTitle tblArtistTrack ArtistID TrackID Compund Key I have set this up as a many to many relationship as...

I am using query by form to display a search from start and end date to find expiry dates for contracts so if the expiry date falls in between the selected date(S) list the results in a subfrm. This all works very well however if I simply type a value of 03/05/05, it is not recognised even...

Hi I am trying to send an email to everyone on my database, upon searching the forum I found the following code but it throws an error "An expression you entered is the wrong data type for one of the arguements" Private Sub CmdEmail_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String...

Can anyone tell me if you can change the background colour of a form depending on a selection. The conditional formatting option allows you to change text box colours if a condition is met. Can this be done with the background colout too?

Sorry to ask a silly question but can you have memo fields on a subform? I have to keep a weekly journal where people can enter comments every week so I thought I could represent the subform to show each week and have the comments listed along side this. or does anyone know a better way to do this?

I have a spreadsheet that I import to Access. The only problem with this is that once the data is imported I am running a query to find duplicates on a name field. The Excel spreadsheet is in the format of Surname, Firstname while the database is set up as Firstname Surname so the names are in...

I'd like to know if it is possible to run a query without first opening it. What I want to happen is the user will click a cmd button and I want the query to run from here without first having to open it then choosing run. How can I do this? Thanks