Search results

Just go back to the base access window and click on the relationships button (3 boxes joined with lines) on the tool bar at the top of the screen. You can set the relationships here - or remove them.

sorry I don't use VB so no code available. Have a go using my instructions and if you get stuck, take a look at Northwind sample database which came with your access package. This contains and example of this and you can analyse the settings etc.

simply go into the design of the form, click on view then properties and set the 'record selectors' choice to 'no' to remove the row selectors on the left of the form( if your using continuous forms) or the 'navigation buttons' choice to 'no' to remove the bottons on the bottom of the form. B...

Hi there, This should be quite simple: In one table, have all the serialnumbers for the product with descriptions etc - this is your top level table. Give the table an ID number column set to autonumber. Base a form on this table showing all fields required and your combo box listing all...

I'm having a problem with my shortcut menus in a database I've just distributed to runtime users. Some forms have a custom shortcut menu for searches etc. This menu works fine on my PC as I have the full-blown Access XP version. However, on the runtime users' PC's, the shortcut menu isn't even...

Try looking at the Northwind sample database that comes with Access. There some exemples of a similar thing that you can analyse. Good luck!

My pleasure !!

Hi Rak, You can do this using an update query. Just create an update query based on your table. Choose the field with the text data you want to change. In the 'update to' row, put: Mid$([Fieldname],2) In the 'Criteria' field, put: Left$([Fieldname],1)="*" Where [Fieldname]...

Sorry - the Title field does contain the '.doc' extension. When it runs, clicking the button gives a 'Run Time Error 53 - file not found' error message. Choosing debug shows the code with 'Call Shell(stAppName, 1)' highlighted in yellow.

Ignore me - I'm a fool! I've just had a better look at your tables etc. and they are what I want, each line holing a different hyperlink. Thanks for stopping me pulling all my hair out. This Forum is great, I can always rely on it whether it's a simple problem I just can't grasp or...

It's me again ! I can't get this code to work - please excuse me being a VB cabbage ! I have the following code running off the 'on click' property of a button which appears on each line of a form in 'continuous forms' view: Private Sub test() Dim stAppName As String stAppName = "C:\Program...

Thanks jfgambit Almost there !! Instead of searching for a file on a server and linking in via the text box, I'd like to have the link automatically created via a field in the table. The table will hold the names of all files in the system. Nice bit of code though !

Thanks for the advice. I typed in the following code into the on click thingy: Private Sub test() Dim stAppName As String stAppName = "C:\Program Files\Microsoft Office\Office\WINWORD.EXE " & [Title] Call Shell(stAppName, 1) End Sub But no joy - it didn't do anything. Did I do...

I am developing a database to control the documentation system within my company. It will control the procedures and who they are issued to. I have the following code which opens a new Word file: Option Compare Database Private Sub word_button_Click() On Error GoTo Err_word_button_Click...

Thanks MJDavie, I've tried this already. It works fine if you know the name of the file and have one button per file. However, I need the button to be on each line of the form in 'Continuous Forms' view. The click of the button opens the file with the same name as a file on the line.

I am developing a database to control the documentation system within my company. It will control the procedures and who they are issued to. I would like it to hold links to all procedures within our system. Is there any way of linking to Word files from within the database, and would this have...

Hi Again, Thanks for the info. but still no luck. I used Alt + F11 to get to the visual basic module then tools, references to list them. There were none marked as missing, just a list that were checked. How do you know if they're missing? Thanks

sorry to be a complete muppet, but having as much luck finding the post on this site as with the help file on my PC, can you just tell me..........oh go on !!

Hi, I have recently upgraded my PC from Access 97 to Access XP Developer (I know, a bit of a jump !!) and I am having some problems with the converted databases. Queries that use the DATE() function are now bringing up the error message 'Undefined function DATE in expression'. Can anyone tell...