Search results

There a quite a few examples around the forum. Try doing a search for 'bookings database'. Also try this link, it contains some data models and how to design a db, It has some useful tips on there, it might help you. Sorry no examples just tells you how to do it. Hope this helps. Andy

Hi Everyone, Thanks for all of your suggestions. In the end I decided to substitue the navigation buttons with my own using [currentrecord] and count(*). Making the number of records highly visible. Appreciate everyone's comments. Thanks to all Andy

Hi All, I have a Continuous form which displays about 5 records at a time, due to multi-function forms that need to be displayed. Basically I want to hide the scroll bars and show 2 text links that say 'Next 5' and 'Prev 5' and to display an image to say end of recordset when reached the last...

jgc31, Bare with me , I have touched access for a while but I don't think you can use docmd.gotorecord,,acnewrec to do what you want. When the form goes to a new record the nav buttons will not show you the other records in the subform which relates to the one side of the relationship, it sets...

SOunds like the master and child fields that link the subform to the mainform is not correct. Check out the properties of the subform to make sure the master/child fields are correct. Normally if the relationship and the subform is linked correctly it should default to a new record when adding...

Have a look at the following webpage: http://eis.bris.ac.uk/~ccmjs/accesswizard.html Alternatively have you tried a complete uninstall , restart the pc's and do a clean 'Complete' installation. Andy

There a couple of ways : you could use a select case statement and the shell command, this option is only useful if there are only a couple of files. Ideally, you should store the filepaths for each file in the table then using VBA code using the shell command to open the relevant file. I...

Thanks namliam, I knew it was something like that :D Yes I am using the time function. The artist formerly known as Mile-O, I know it was 1am when I wrote the post. Thanks Andy

Hi All, I'm very tired and this is probably stating the obvious but I want to assign a value if the time is between 6am and 2pm. What is the syntax in VBA? if time = >#06:00# or <#14:00# Then 'assign value here end if Not quite there. Anyone help, gone a bit rusty. Thanks Andy

Hi Ken, Thanks! Funny thing is that the number fields are set to double. I just thought it might be a problem with access when using linked tables, i thought i read it somewhere. Andy

Hi All, I have been running a program now for six months and all of a sudden when the data is imported from three excel spreadsheets I receive the error : Error 3349 - Numeric field overflow on a docmd.transferspreadsheet line of code in vba. I have narrowed it down to one spreadsheet and...

Gary, I use the following code to delete import error tables. Dim db As Database Dim tdf As TableDef Set db = CurrentDb For Each tdf In db.TableDefs If tdf.Name Like "E*" Then DoCmd.DeleteObject acTable, tdf.Name End If Next Set db = Nothing Generally the import error tables in my...

Hi, Try this link . It basically exports data from a query and uses a template file to autofill the data by linking the query data to the worksheet that is formatted. Take a look. This has helped me out before. Regards Andy

Never tried this but you could 1) Set up the fax printer through windows built in fax program 2) Set the tables up and using VBA sending the fax by defining the windows fax driver like you would to define a specific printer. Just a suggestion, this might not be appropiate to your query but...

You will find the answer by searching the forum. Here is one link in particular http://www.access-programmers.co.uk/forums/showthread.php?t=53501&highlight=remove+security Andy

Hi Wayne, I'm around just really busy. Hope you are well! You did get the right db. Tidman, The db 97ver works fine for me. Have you tried re-downloading just incase the download was corrupt.? Andy

Silly Me!. I forgot to have the form open that the query relates to. Seems to work, just need to change it now to automate it from a button press. Thanks Hayley. This problem seems to be quite common. When I have completed it I will post a sample db in the sample db section for future...

Thanks Hayley, I have had a quick look and it won't work, because I am using a parameter query as the data source of the report. I will keep trying though. I am also working on doing it through PDF...PrimoPDF. Thanks Andy

Hi All, It's been a while. I have created a system where I want to email a report to a third party in a particular format, basically in Snapshot format. The problem I have is that they don't have access to the format and I am trying for them for there IT to get it installed. Is there a way...

Next Time! ;) Took the wife and the little one, beautiful country. Andy