Search results

Thanks for the reply Vince. No conversion has taken place. We were working off Access 2002 and now moved to Access 2003. I have both versions on my PC. 2002 works as it should, 2003 doesn't. In 2003 I have also created a new DB and form, and made sure that all start-up toolbar events are...

Morning All, We have just upgraded to Access 2003 and have come across an issue with the TOOLBOX functionality. When I have any form open in design view, and try clicking on the TOOLBOX to insert my objects, nothing happens. I have tried accessing the toolbox using various shortcut methods...

Hello All, I have the following line of code ... DoCmd.SendObject acSendQuery, stDocName, acFormatXLS, EmailAddress, , , "Outstanding Orders", "Please find, attached, your outstanding orders." & vbCrLf & vbCrLf & "Regards." I have omitted FALSE at the end so that the message opens on screen...

Hi Dave, Thanx for yr reply. I originally had the data on one form and all in one table i.e. NAME > NAT_INS_NO > COMBI EXPIRY DATE > REACH EXPIRY DATE etc. The problem I had is that I wanted to create a query which produced the expiry dates, for all trucks, combined into one (in ascending...

Hi All, In form MAINFORM (of the attached db) there is a subform. The idea is to have the subform automatically display the current list of trucks available (based on qry_truck_types) when the form opens. This way, a user only needs to enter the license "expiry date" alongside each one...

Ashfaque, I had to change NOW() to CDATE(Date), but the form works fine now. Thanks for all your help. Regards, PAUL.

Thanks Ashfaque for the coding. It works well. The only other problem is with the date picker. If you set the CONTROL SOURCE property to NOW() and then then try and choose a different date, it won't allow you to. There is also a VALUE field property, but it only allows you to enter a...

Hi All, FORM1, in the attached DB, is used to calculate hours between two times. The two issues I have are: 1) In the RESULT (HRS/MIN) field, how can I get the value to appear as HH:MM? 2) In the date picker fields, how can I set the value of the field to the current date when opening the...

I suppose you could create three copies of the report and change the label in each one. Behind the the print button, write three lines of code for each separate report. Regards.

Hello All, This must be such an easy problem to resolve I feel almost embarrased to post the thread! But here goes. I have a textbox on a main form which is linked to the OnTimer event to show the current time (seconds included.) When you left-click on the form and keep the key pressed, the...

Try this. Regards, L.

Hi Crillen007, I am running Access 2002 (SP1). I have attached a copy of the form (stripped of all the coding). It seems to hug the top of the screen when the modal and pop-up is set. Regards.

Thank you Mile-O-Phile for the response. As mentioned in my post, I have set the form's AUTO CENTRE to "YES", but this doesn't cente if the POP-UP and MODAL properties are set to "YES". Regards.

Hello All, If I set a form with the following properties (see below), it does not centre on screen. It tends to place itself near the top. AUTO CENTRE = YES POP-UP = YES MODAL = YES However, if I change the POP-UP and MODAL properties to "NO", the form centres itself. How can I get the form...

Good evening All, This has been doing my head in for days and have read thread after thread without any luck. I have a main form with 1 subform in it. These are linked via child fields and by separate tables. The subform's details view is set at continuous and users will enter product lines...

I'm hoping someone can help me on this. I have a main form linked to "tbl_orderheader" and a subform linked to "tbl_productlines". These are linked via child field "inv_no". If the cursor is in a field of the subform and I mouse-wheel scroll, the data moves up and down and remains visible...

Try using "DOCMD.SETWARNINGS False" at the beginning of the code. At the end of the code add "DOCMD.SETWARNINGS True" This command basically turns 'off' and 'on' the Access in-built information messages. Regards.

Thank you GHudson. You have solved my problem. Much appreciated. Regards.

Hi Ken and thanks for the swift reply. Yes, I will be doing calculations on this field. Part of a non-conformance database. I don't want to allow the user to key in a decimal value by mistake. Example: original entry was 10.05, confirmed entry 10 - this would show as a non-conformance...

Good morning, Whenever I set input masks for a currency field, i.e. #####0.00, this allows me to input any figure from 0.00 to 999999.00 which is what I require it to do. However, if I set the field property to NUMBER and an input mask to ####0, it seems that I have to input proceeding zero's...