Search results

Hi JANR Just tried that, I removed the querydef, and get the message "Too few parameters. Expected 2." The code now appears thus: Private Sub cmdSendEmail_Click() On Error GoTo Err_cmdSendEmail_Click Me.Refresh Dim db As Database Dim recBookingQry As Recordset...

Thanks for the reply JANR. I had just figured out I hadn't put a where clause in the query just before you replied. I applied your suggestions and got a "Too few parameters. Expected 2" message. I made the following changes (in red): Private Sub cmdSendEmail_Click() On Error GoTo...

Can someone please look at this problem and suggest a solution? I would greatly appreciate it. I only need a bit of code to select the current record on the form with the 'send email confirmation' button. Cheers

Hi All Below is a click event which sends the data in a query to Outlook and emails it. It works a charm though I'm sure it lacks programming finesse as I am a novice, but books and the web have got me this far. My question is this: the click event is on a form showing one record, how can I...

Thanks for the offer, James. I'm off this project now and will on field work for the next two months, so I'm going to put the problem on the backburner. I found a post on another forum site which said you cannot filter a subform from an OpenForm method as it only refers to the main form. I did...

Thanks for the attachment James. Still not working, when I applied your suggestion, the client details didn't load. Prior to that I got the correct client but the enquiry was simply the first enquiry. Thanks for your efforts. Any other thoughts would be appreciated. In case it is useful, the...

Hi James Done that but still no luck. It prompts me for the EnquiryID. If I type in the number I want, I don't get it. It returns the first enquiry connected to the client.

Thanks James, unfortunately it didn't work. I presume it is because the [EnquiryID] is on a subform in the form I'm trying to open and cannot be seen by the code above. I modified it: DoCmd.OpenForm "frmClient", acNormal, , "[ClientID] = " & Me.frmsubClients![ClientID] & " AND...

Hi all I have a form which lists records from a search in a datasheet view. I want to open another form based on a selected record from that search. I have achieved this with DoCmd.OpenForm "frmClient", acNormal, , "[ClientID] = " & Me.frmsubClients![ClientID] but the client also has...

No not spam. You don't have to be a full-time student either, I'm not. You just have to be registered with one of the institutions on the website. An Athens logon would help you as well. The files are downloaded as .iso or .exe.

Apologies to the moderators for posting here but I wanted many to see this. http://downloads.channel8.msdn.com/Default.aspx Follow this link for free software, the titles are listed below. There are two requirements, 1. You must be a student. 2. You need a hotmail type passport, you know what I...

I presented my arguments but they weren't enough to convince my colleague, she is happy to rely on cascading updates to sort out errors.

Yes, plus the staff selected to input data will be on the whole ignorant of Access, especially how the data are structured and related. Corrected errors will orphan related data but the inputter may not realise and leave the related tables unchanged. Such holes may not be discovered until after...

If the PK was in a simple look up table I don't think I would be worried as much, but it's not. The database being built will record archaeological data. One of the primary keys will be a context number (a unique number assigned to an archaeological event on a site, e.g. the cut of a ditch, a...

The gravity of this scenario has just hit me. Without doubt, someone at some point will type in the wrong value and it will have to be change. Oh, boy!

Thanks Bob and George, good posts. Anyone else want to jump in the ring. I'll pull up this thread and show my colleague so we can carry on the debate.

Hi all I have been discussing DB table design with a colleague and we have a difference of opinion with regards to primary key ID fields . My argument is that they should not be actual data but separate, that is an unique record identifier typically an autonumber type. I'm sure I picked this up...

I'm a newbie with a simple question for the experts. Say you wanted to build a database for distribution that was multiuser and worked over a server; given a choice would you build a database entirely in Access using modules for full functionalitly, or use VB .Net to develop the forms and code...