Search results

I am using Access & Word 2003. When I merge to word labels using an access query word sorts the data in ascending order even though I have sorted it descending in access. How do I stop word from re-sorting. Thanks in advance.

I have tried to use Bob Larson's, "zsfrmCalendar" but am having the old UK - USA date format problem. I would appreciate it if someone could look at my sample and provide a solution. Thanks in advance. PS Bob thanks for "zsfrmCalendar" anyway.

If you open the attached sample db you will see that I have a cascading combo box (It is working fine). The data for the tables that are the source for the combo box are imported from an excel sheet.(This works fine) Now my problem the data from excel is variable after the data is imported...

If you open the attached sample you will see what my problem is. I have Form /Subform with look up combo that will not allow duplicate entries in same subform record. This works fine, access displays an error when a duplicate has been added as it should. What I want to do is trap that error...

Attached is a cut down version of a db that I have,my problem is the date format I use dd/mm/yy, my date settings in the control panel are the same. If you have your computer set to this format then change the date of your computer to 07/11/04 . The reason for this is because I know that there...

I have a form (frmPoints) with a subform (frmPointsDetail).They are linked by PointID (master) and pdPointID (child) they both work fine On the subform (PointDetailsID)( PK) I have a combo box that has “Locations” (Kitchen, Bathroom1, Bathroom2,Lounge, Bedroom etc) this gets its information...

I have a continuous form that has two fields’ txtCusNameAndAddress and txtIncludeInMerge. txtIncludeInMerge is a tick box default -1 The user can “un-tick” the tick box next to a customers name and when the “Continue” button is clicked, the record is saved and the “un-ticked” customers are not...

I have a form that is filled in by data from a table and is saved to a second table. This for creating an invoice from customer table, the reason that I do this is so that the invoice has the correct details at time of creation. If the customer address changes the previously created invoice...

I am using access 97 Can anyone see what may be wrong with this code, sometimes it works and other time not. If the record count is greater that 2 the header will say Vehicle NOT Returned, then if switch to design view and then back it will say Vehicles Not Returned (which is correct). This...

I have following and would like someone to check to see if the setup is OK. If I have not explained clearly, let me know and i will post a sample db. tbl_deliverydates deliverydateID (PK) DeliveryDate One DeliveryDate can have many Vehicles tbl_vehicles vehicleID (PK) deliverydateID (FK)...

What I am trying to achieve is when this form is opened on a Monday then it will show previous "Sunday & Saturday & Friday" details. If it is open on any other day then just the previous day.(this part is working fine) The code below works fine for strSaturday but I want to combine strFriday...

Would someone be kind enough to tell me what I have done wrong in the code show below? Access is give me error 3075 Syntax Error (Comma) in query and is highlighting the last line in my code. DoCmd.Openform stDocName, , , stLinkCriteria What I am trying to do is open a form with only...

I would like someone to have a look at this and tell me where I have gone wrong in the second procudure. Thank you in advance This works fine (I download the "SampleSearch.mdb" and modified it ) Private Sub cmdSearch_Click() On Error Resume Next Dim sSql As String Dim...

In the attached sample I have go one type of combo box to work but the one using a number I cannot get it to work. I hope that someone can offer assistance. I have become brain dead trying to solve this. Regards, :confused:

I have a combo box on a form with the following code in the after upate; Code Private Sub cmboFilter_AfterUpdate() If Me![cmboFilter] = "<All>" Then DoCmd.ShowAllRecords Else DoCmd.ApplyFilter , "[RegistrationNumber] = '" & Me![cmboFilter] & "'" End If End Sub Data Source SELECT DISTINCT...

I am using Access 97 for this database (I also have Access 2000) I have attached a small database sample that I am having a problem with. When you open the database you will see a form called Vehicles with a subform attached. The purpose of the database is for vehicle use, the vehicle has an...