Search results

Forgive the length of the post but decided I'd best put in some sort of explanation with the expression. The following expression will give you everything after "itemnumber=" or any particular text string you want to find text after, if it exists in the string. Expr1...

Try the following link, the downloadable file is very useful in compacting the open database. http://www.mvps.org/access/modules/mdl0030.htm

Grouping by branch and then user should give you the results with one occurence of each user in each branch. If the report is giving you more than one line for each user then it implies that your grouping contains something other than Branch and User which causes the multiple occurences. Best...

Can't think of any reason why the linked tables are not showing the up to date data as that's the whole point of linked tables. In relation to 'Linked Table Manager' it's used generally to refresh links if the database has been moved to a new location.

I don't know of any particular way of getting your query to result in 5 columns, a crosstab would normally be used but you wouldn't have enough data with only 2 fields to do a crosstab. If it is only to facilitate the display of the results and the number of Payment Forms is fixed then you...

Use the 'Linked Table Manager' under Tools/Add-Ins for A97 or Toots/Database Utilities on A2K. This will open a window to allow one to select the linked tables and then refresh the link by pointing to another location.

There is a product out there called 'Handy Access Launcher' or HAL that allows one to schedule the launch of Access applications. I have not used it so can't really vouch for it but it might solve your problem.

No real idea if this will work but try putting in the following after what you have in the command line at the moment. \ini "full path location of ini file"

Create a query and use Max([YourDateField]) to find the latest date. Another option is to create a query with YourDateField in descending order and use Top Values to select the Top 1 value.

Create a query with the expression below for your date field and then export the query to the text file. format([YourDateField],"yyyymmdd")

Ally, I created a similar query, in A97, and it worked fine, if I entered 01/01 and 01/08 then I got 'January 2001' and 'August 2001' for StDate and EndDate. If I entered 99/01 and 00/04 I got 'January 1999' and 'April 2000', it worked for any combination of parameters and selected the correct...

Instead of just Forms!frmSelectCity!cboCity type [Forms]![frmSelectCity]![cboCity] and so long as you have the form with the combo open the query should run correctly.

Maybe this will solve your problem, build a query with the following SQL, substitute 'a' with your table name, 'Agent_no' with your employee id field and 'Appt_date' with your birthday field. SELECT a.Agent_no, a.Appt_Date, Day([appt_date]) AS BDay, Month([appt_date]) AS BMonth FROM a WHERE...

Few options here either use condition in Macro or use code which you can then call through RunCode in Autoexec. 1) Using condition Create a second Macro to print the second and subsequent reports if user answers Yes. Change autoexec to have condition, within Design click View Conditions...

Not sure if the following samples deal with exactly what your trying but there is a good example of using a form to filter or order a report in the database for download here http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175072