Search results

What are you setting stLinkCriteria to? SteveA

If you change: Fdf_Output.FDFSetValue "AgentFulla", rstClient("AgentFulla"), False to Fdf_Output.FDFSetValue "AgentFulla", NZ(rstClient("AgentFulla")), False it will write a zero length string rather than a null value to "AgentFulla". You can also set the optional 'valueifnull' argument to...

You can do a search using the LIKE operator by placing all the characters you are looking for inside square brackets. ie: Like "['@$]*" This will return any entries that contain an ', @, or $ n the first space. To search for it anywhere in a string, you can change the Like statement to read...

If the Main form displays an Order, and the subform displays OrderItems, does clicking the command button open a window to add or modify OrderItems related to the current Order? Cheers, SteveA

If the subform is showing all orders for a particular customer, wouldn't the master/child relationship be the Customer ID in both tables, not the Order ID? Cheers, SteveA

Is the command button on the sub-form itself? If yes, is it in the header or footer of the subform. If a subform has no records to display and doesn't allow new records to be directly entered, it will only show the header and footer. If this is the case, add a footer to your subform and...

Try the following: Set rst = "SELECT ([flights].[departairport], [flights].[arriveairport], [flights].[traveldate], [flights].[duration], [flights].[flightname], [flights].[price], [flights].[flightsresortid]) FROM flights WHERE ((([flights].[traveldate]) Between #" &...

The following function will find the next Thursday after today. This function will always find the next Thursday after today (no matter what today is: Monday, Wednesday etc) =DateAdd("d",12 -WeekDay(Date()),Date()) If you are wanting a date that is 7 days from now, you could enter...

The DoCmd.OpenReport option allows you to pass a filter to the report. Perhaps you could build a Filter when the user clicks the Print button and then pass that filter in the OpenReport command: DoCmd.OpenReport [ReportName],acPreview,,[FilterRule] The record source for your report will not...

Have a look at the recordsource for the report that works and for the report that isn't. It sounds like the recordsource to your labels report needs to have the Postcodes table added and linked using the SuburbID. Instead of displaying the SuburbID field on the report, change the source to the...

Instead of [Length] & """ try [Length] & '"'. The change is subtle, but it works in queries. It should work in reports as well. HTH SteveA

Your query probably has a line like: Where [FieldA] = [Forms].[MainForm].[Value]) I changed this to be the following: WHERE ([FieldA] = [Forms].[MainForm].[Value] and Not IsNull([Forms].[MainForm].[Value])) or (IsNull([Forms].[MainForm].[Value]) This can get a bit awkward when using many...

The OrderBy property is a string expression that is the name of the field or fields on which you want to sort records. When you use more than one field name, separate the names with a comma (,). When you set the OrderBy property by entering one or more field names, the records are sorted in...

What are you attemtping to do when the system error is being prompted? Access handles different errors in different ways. SteveA

You might be able to use the DateAdd function in Access. =DateAdd("d",NoOfDays,#02/01/1978#) Cheers SteveA

You could also write code to loop through the controls collection. ie Dim ctl as control For each ctl in Me.Controls If ctl.ControlType = acTextBox then ctl.Value = Null end if Next ctl Cheers, SteveA

Hi again. I would probably break the Hotel table into two separate tables. One table holding the hotel and which resort it relates to (Hotel), and the second table holding the rate, date and which hotel the rate relates to (Rates). I hope this helps SteveA

I'm not sure about the sequence of events being triggered in this scenario, but maybe you can set a public variable (ie blnLoaded) to false in the OnLoad event and then check this value in the OnCurrent event. HTH SteveA

Try writing a union query to join all the various tables together. Once this is done, you can use the query as the source for your listbox. HTH SteveA

Given that you are not actually changing or manipulating the field txt_from, why not try using that field in the INSERT statement. I haven't tried this. Only guessing SteveA