Search results

Thanks for the input TJ. If the folder is not found, windows throws up a Warning "The Path C:\Mydocuments\Customers\Fred Blogs Pty does not exist or is not a Directory". I've searched the Internet, but can't find a suitable code for the warning. Is there such a thing as Warning Handler rather...

Thanks namliam, but surely there is a way of "masking" the input so the team can still enter data in the national format? You'd still have to put the table into US but can the input be UK style

Bit of a problem here that I can't seem to find an answer to anywhere. I've started with a Listbox in a Form from a Table of meeting dates from which I highlight a date ane try to recall information about the meeting (past or proposed) from the main table by clicking on a button which in turn...

Help please Anybody ??

I'm still very new to this game and have been searching the Internet for bits and peices that I then build into something that generally works! I'm now attempting to use a button on a form to open a sub-folder that is held in My Documents folder, "Customers". The Sub-folder name is that of the...

Almost Bob, but it seems to just miss the point. My regional settings are for Australia; the information coming out of the Code / process is in the correct format (dd/mmm/yyyy - as seen in Immidiate); the information shown in the sql of the query is in American format (mm/dd/yyy - as it says it...

New Problem.... If I enter a date that is below the 12th of the month (i.e. 1 July 2013), the date that appears in the sql / Immediate is correct, but the date iin the query criteria comes out in the incorrect format. (07/01/2013) If I enter a date that is (say) 23 September, it goes into the...

Works a treat thanks Bob. Just need to sort out how I get the date into "English" rather than American now!! Actually, I've just noticed that the Immediate shows the date coming out in English. The date in the query is mm/dd/yyyy though

Hi Accessers! Another little thing that is driving me insane and that I can't find an answer to on the forum or through Google! I have a process that lifts a highlighted date from a List Box and puts it in the Criteria of a query. The process manages to move the numbers from one place to...

Oops! I've been leaving the old way in. Meant to put an ' by the second line of strSQL. End sub is a lack of concentration....... Thanks Pat. I'll try this all out next week (at work):D

OK. I've removed the Open / Close bit, but still get the Syntax error Missing Operator in query expression tbl_CSM_in Current sub routine is................. Private Sub Toggle4_Click() 'Set it all up for CSM selection Dim db As DAO.Database Dim qdf As DAO.QueryDef Dim varItem As Variant Dim...

Yes. Before Call Toggle 10 I have the following... ' put it in the Query Debug.Print strSQL qdf.SQL = strSQL qdf.Close 'Open the query to view DoCmd.Close DoCmd.OpenQuery "Qry_All_CSMs_Projects" DoCmd.Close acQuery, "Qry_All_CSMs_Projects" DoCmd.OpenForm "Frm_All_CSMs_Projects" ' Finish...

Hi Pat. Literely nothing happens when I click on the button in the form. The button changes to "Hover" and "Click" colours, but the form stays in place (it should close) and there is no error warning. It's as if the button has no effect at all. Having said that your latest input works up to...

Thanks madefemere. Not sure the "all" code will work. I've done the selection by having the listbox associated with the CSM query selecting names from a table of names. The CSM query is then linked to the CSM field in the main projects table so none of my queries appear to have the...

You saw through my facade and into limited knowledge Pat! So i've inserted the following into the IF statement If Len(strCriteria) = 0 Then strSQL = "SELECT * FROM tbl_CSM " and nothing happens.......! I'm missing something aren't I? Is there any way I could add "All" to the names listbox...

Hi Accessers! I've got a code that allows me to select one or many names from a listbox on a form and return data relevant to the name(s) selected from a query. The following code is triggered by a button on the form... Private Sub Toggle4_Click() 'Set it all up for CSM selection Dim db...

That seems to work thanks to all.

Thanks Galaxiom; I'll try that on Tuesday when I get back into the office. I've used a list for another function of the db and was considering using a text box to drive this, but still needed a steer as to how to achieve the result. (Relatively new at this game!):banghead: And yes CazB, the...

Hi Accessers! I have a database that is used (partially) to enter appointments during a day. In the appointment column I've entered the date and time as dd-mmm-yyy-hh-nn-ss. I'm now trying to search for appointments entered on a specific day through a user input ([Enter Date] in the query...