Search results

Adam, The way the sample is done is to show you how a relational database works. The form displayed is for data input purposes, if you want to see all the purchases for a member of staff then use create a query/report/Form to pull the data you want to view. As an example if you open the...

Adam, See attached sample. Look at the table structure and relationships. Note I have including the CustomerID field in both tables and set a one to many relationship. I simply used the form wizard to create the form that opens up by selecting all fields from both tables. This should point...

Thanks Pat, It's been a long day. Andy

Juan, Take a look at this microsoft help article: Article - First and Last Record I suppose you could always use DAO/ADO to retrieve the info you want. See if the above info is any use. Andy

Create a textbox and set the controlsource to: ="Jan - Dec" & " " & Year(Now()) You can Hardcode the Jan - Dec and get the current year from today's date. Hope this Helps Andy

You could write the code something like If me.field = 1 Then 'Do something ElseIf me.field = 2 then 'Do something End If End if or you could use a select case statement Select case me.field Case >= 1 'do something Case>= 2 'do something Case >= 3 'Do something End Select Hope this Helps...

Maybe this link will help Click Here This looks at the Insideheight settings of the form. Another suggestion could be to add subforms and then set there visible property to true or false dependent on the users selection. Never tried it so I hope this helps Andy

Adam, Firstly welcome to the forum. You can have a main form which displays your customer details and a sub form that is linked with your customer form and the default view is set to continuous view. For this to work your tables need to be designed with a 1 to many relationship on the...

Juan, You could create a textbox with the following controlsource: DMax("[Field Name]","[Table/Query Name]") This will return the maximum value entered or Dmin will return the lowest. Search in Access Help for DMin and Dmax and it explains how you can use criteria to return the max or min...

Jay, Go to the following menu path: Tools > Options > On the View Tab there is an option 'Hidden Objects' Click the checkbox and click OK. You should now be able to view your form in the database window. Regards Andy

Wizcow, If this database is multi-user , do the other users have the program installed or is the generated help file in a global file extension that windows recognise. Could you provide a link to the software? If you are opening a program then it should be as simple as: 1)Creating your menu...

Umer, Visit the following link and look at the one titled Report Utilities. http://www.lebans.com/Report.htm This is the sample I downloaded at the time. Cheers Andy

This is what is says in the Help File. Microsoft Access stores the settings for page setup options with a form or report, so you set these options only once for each form or report. For tables, queries, data access pages, and modules, you must set page setup options every time you print...

The only thing I can think of (I'm a bit rusty of late) is to check to see if there is a .ldb file in the same directory has the backend db. If so delete the .ldb file and try importing into a new db. Other than that I can't help I'm afraid. Don't you have a backup up copy that you can refer...

Razorking, Glad you worked it out. Personally I never use the hyperlink data type. Good Luck with your project. Andy

Kev, No you can't turn it on or off, it's either installed or not. I might be going down a dead end road here, but have you tried it without the nz function. If it works then it could be the installation or the version of access 2003 installed. If the click on Help > About and the version...

Works Ok for me. Check your references to see if they match. I noticed you are using the NZ function on the textbox, check to see if this is available in the version of access on the 2 PC's. Are you using an exact copy of the db that works on the other pc's Apart from that I cannot think of...

Razorking, It's probably due to the fact the the column in the query/table is set to a column which is not the link field. I have attached an example for your info, I have dimensioned the address for application.followhyperlink variable. Dim link as String link = me.list0.column(1)...

Razorking, Use the following: Application.FollowHyperlink Me.List2.Column(0) If the link is in the first column leave the 0 in brackets otherwise change to 1 if it is the second column in the listbox, 2 for column 3 etc etc. Don't know why I suggested the previous code, wasn't...

If you are using a listbox try something like : Application.FollowHyperlink me.listbox.selected Andy