Recent content by sneapdogg

Hi guys, This is realy bugging me. When i select multiple cells from a query to paste into RUMBA Mainframe it pastes the column name at the top every time. Can get it to copy just the cell data without column name if i do it one cell at a time, but im doing 10+ cells at a time and i dont have...

Good point Bob wouldnt have realised that till jan's reports. Thanks guys, problem solved! :)

Thanks, sorted it.

I have a query to add total user DOS requests up for the month. Each record added is datestamped. My count and sum query adds user totals but is adding totals for each day rather than the whole month so users are showing up several times. Any idea how to stop it doing this? I have the...

Cheers JANR thats sorted it. Works a treat :)

Moved it to the VBA module but getting syntax error and its highlighting the following. Private Sub postcode_AfterUpdate() =Me.email=DLookUp("Mailbox","PAV emails","postcode = '" & Left(Me.postcode,2) & "'") End Sub now i'm lost.

Done the following as suggested: =Me.email=DLookUp("Mailbox","PAV emails","postcode = '" & Left(Me.postcode,2) & "'") but when I type a postcode in I get the following error: The object doesnt contain the Automation Object 'Me.'. Not sure why i'm getting this, can anyone point me to the...

I'm quite new at this, can you take a look at the screen shots of my table and my form and explain in a little more detail how to do this. When i type a postcode in to the postcode box on the form, i want it to show the email for that postcode from the table in the bottom box of the form...

change subform boarder colour to same as back colour.

In form properties of each form change "record selctors" to no also do same for "navigations buttons" and "dividing lines" this will remove the obvious lines and buttons around each subform. also change the back colour of each form to the same colour. Then it will look like just one form...

Hi guys, I have a database to record daily issues to be resolved for my team. I have a form where a customers postcode is entered and from this entry i want access to automatically fill in the corresponding email for the team that will deal with it so I can just copy and paste it straight into...