Recent content by Iwra

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

That's resolved the problem of the input mask. I can now have an input mask on the form and not get the type mismatch error. However is is now returning incorrect records in the search :confused:

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

Bukhix, thanks for the reply but the code is not doing anything for me. No error messages just doesn't do anything. When I take the lines to capture the Contact out then everything works fine. Any ideas?

I resolved the above error. Now I'm trying to ad the name at the top of the email Hello ContactName then the body of the email underneath, this time I get an error saying "Arguement not optional" Private Sub CmdEmail_Click() Dim rsEmail As DAO.Recordset Dim strEmail As String Dim strBody As...

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

Hi Hayley posted a sample in this thread that I used myself. Not sure if this helps you http://www.access-programmers.co.uk/forums/showthread.php?threadid=33252&highlight=open+a+report+from+a+combo+box

Thank you Rob I will try that.

if value in a text box equals certain colour then background colour changes to match that colour. For example Make selection from combo box selection1's colour = green so background colour of form changes to green.

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?

Thanks to you both. I will read up on this Doc Man, I know a little VBA but am not too advanced as yet. I'll have a play around with this and see what I can get to work for me. Cheers

I thought about changing the format of the spreadsheet but only problem with that is that it is sent onto me every month in this format (one column with Surname, Firstname) So I would have to change this every time the latest spreadsheet is sent. I just thought there might be a way to change the...

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