Search results

Why not Link the required tables?

Try using AND instead of IIF ; AgentNo: IIf([strAgentNo]="67322" AND Right([strProductCode],2)="12","29221",IIf([strAgentNo]="29221" AND Right([strProductCode],2)="24","67322",[strAgentNo]))

You could try holding down the shift key when you open the database. If this lets you in select Tools - Startup and tick the options you want available when you open the app.

Hi Andy Try Screen.ActiveForm You could try disabling the controls as the default and then enabling with the following. Dim ctl As Control For Each ctl In Screen.ActiveForm If TypeOf ctl Is TextBox Then With ctl .Enabled = True End With End If Next

Try: Format(begin_date,"dd") & "-" & Format(end_date,"dd")

If you are using Windows why not use the Remote Desktop Connection? It's pretty easy to set up - you will need the IP address of the server you are connecting to and an account with remote access enabled on the server. I connect to a couple of clients servers this way - have no problems with...

Thanks for response. It was the euro symbol I was struggling to display. CTRL + ALT + 4 worked fine. As per Simons suggestion good idea to put symbols in a table. Problem solved. Cheers.

Thanks for reply Kiwiman. I cannot format the control to euro as it also may be dollars or sterling. I can detect what currency the value is but then need to apply the correct format.

I cannot find this anywhere!!! Can anyone tell me how to format a euro symbol using MS-Access 2000? I have the current format set but would really like the euro symbol rather than 'EU'. Curr1: IIf([curr_code] Like "EU*",Format([Local Value],"\EU0.00"),Format([Local Value],"$0.00"))

Hi My wife owns a small cafe - she rents the building from a landlord. We have heard rumours that the landlord is going to 'go bankrupt on paper'. What does this mean and does it give my missus any reason for concern?

You could do it using Windows Scheduled Task. When you have selected the database to run put /compact after it.

Open the query in design view - the field 'Response Time' contains the calculation you need.

DateAdd will work using hours. I've taken this from a query - hope you can follow. Time: Format(Now(),"dd/mm/yy hh:mm") This gives you the current date and time. Timeplus: Format(DateAdd("h",16,[Time]),"dd/mm/yy hh:mm") You can replace the '16' with the hours in your priority table. If it...

Try setting the 'Start in' option to - "C:\Program Files\Microsoft Office\Office"

I have always liked Richard Feyman's view on religion etc. http://www.youtube.com/watch?v=zeCHiUe1et0

I use the following method. In modules create a new module (I usually call it functions) and type the following code Public Function find_files(tablename As String) As String Dim dbcurr As Database, intfiles As Integer find_files = 0 Set dbcurr = CurrentDb For intfiles = 0 To...

Hi, I'm sure I have done this before but cannot recall. Using Windows 2000 I need to expand the list of recently opened files for a third party software package. It is currently set to show the last 5 files opened - I need it to show the last 6! There is no option within the...

Create a 2 line macro using the OpenReport Action. Set the report name on both lines to DetailedInvoice.

I had not thought of that Wayne - however there are no relationships defined - so it isn't that. The application needed some tidying up and when I added a condition at the DeleteObject line which called on the results of a function that checked the existence of the table by using TableDef it...

Has anyone else come across this problem in MS Access 2000? I have an application that updates from an ODBC source overnight using a macro that is run from Scheduled Tasks. There are several tables that are first deleted using DeleteObject and then re-impoted using TransferDatabase. However...