Search results

Hi namliam & MarkK I am now getting an Enter Parameter window for txtBookedDate when it’s a Append query. So Append queries only append from Table/Field to Table/Field. Can’t believe over the years I haven’t had a similar issue, anyway I was originally only using the select query to check all...

Hi MarkK Hmm Ok i will check in the Append SQL in the morning....Any ideas on the CDate part to simply converting the ddmmmyy text value into a dd/mm/yyyy date value?

Hi All, Its been a while I Keep getting an #Error result on the CDate function 1st step works fine txtBookedDate: Trim(Mid([BookingDumpScreen],InStr([BookingDumpScreen],"P.")+4,8)) Answer as expected 07JAN15 2nd step converted the text to date Tried BookedDate: CDate([txtBookedDate])...

IE11 & Access2013(Desktop) Hello....I was wishing to automate a process at my work:- 1. I Highlight a text value on a website then ctrl&c 2. Alt&Tab to Access 3. Press F3 on the keyboard to open a search form 4. Ctrl&V paste the value I presume I will have to make up a toolbar in IE to add...

Anybody :(

Help anybody?

Is it possible to specify a add-in IE toolbar (Lastpass) to load up with a form browser control. I understand its possible to pull through the main cmds GoBack, GoForward, Stop, and Refresh etc but I need the lastpass toolbar to load. Thanks Win7 / Access2000 / IE8

I was trying to use the example Dave gave me with the Then at the end. So a “Then” is used when is a “IF” not a “IIF” ? Also I don’t understand “leading spaces” is that not to do with Trim function I must admit I just can’t get my head round the structure of this. I am officially lost Stewart

Never put together a multiple IIF before. This was fun typing this out on my Mobile !!!. Back in the office on Monday Will this code work ? Thanks Stewart Private Sub Form_Current() IIf (DCount("*", "frm_ClientsMedicalDetails", "[pid]=Forms![frm_clientmasters]![pid]")>0 ) Then stDocName =...

Ok DCount it is then Looked at the Access help pages their was an example “There are more than three entries in the Order Details table for which the OrderID field of the table matches the OrderID field on the Orders form. “ DCount("*", "Order Details", "[OrderID]=Forms![Orders]![OrderID]")>3...

Hi Allan thanks for taking the time to reply Due to screen size restrictions the original frm had a TabCtl & Subforms, But my colleagues just didn’t look through the tabs I thought if i changed the other forms to popups this would force them at lest to look at them and further down the line...

Hello I have small .mdb containing these tables tbl_ClientsMaster (Primary Key) (PID) All linked to above by PID tbl_ClientsMedicalDetails (PMDID) tbl_ClientsExecutiveCards (PECID) tbl_ClientsPreferences (PCPID) The tables all have corresponding forms When the frm_ ClientsMaster loads I...

Bump! Anybody

Hi All I used to have a great sample mdb that was written by a MVP The sample was one of a series of online articles with a downloadable sample at the end This example covered going on to a website (featuring their books) then capturing the screen details I was a great example on how to...

Thanks for the Const advice. i also tried replacing the Const line with some string combinations below but still no luck, I get the same message “Invalid outside procedure” Dim cPath As String cPath = "C:\" & Forms![frmListBox]![CLIENTID] & "\" I have uploaded a cut down .mdb example based on...

I have been trying to change ghudson great example to fit in my database My plan was to:- Change Combox to ListBox...Done OpenFile from Combo (AfterUpdate) Changed to OnClick...Done Change C: to Display Files in Current records folder in the server Sooo my missing part of the puzzle is get the...

Thats the one Well done on the leap from "pitbull or bulldog" to Datapig You dont do lottery numbers as well? Cheers DaaAgent:D

Anybody???

Could anybody take a look at a old post Cheers

Hi I have lost a link for a great website that had online video tutorials in Access. It was pitbull or bulldog or something like that (tried all the combinations in google) Jog anybody’s memory for a url cheers