Search results

Well that would be interesting to watch ! Anyway. Firstly I would have the auto filled fields set up in form current. When I want to add a new record i will click on a cmdbutton which auto fills the ID, date received and works order based on whatever such as ID + x. In form current you could...

I have also had this problem very recently. I solved it but can't for the life of me rememeber what the problem was or how I solved it. If you want to send me the dbf I'll have a look for you. I think it will be something like the wrong source data /form name / wrongly typed or specified...

Hi everyone, Thanks for reading/ any help... I have a form with 7 field for names and 7 fields for points. Users enter their name and later, points are allocated to the relevant points fields. I am trying to get a summary report to show all the points for an individual user. The problem is...

I have a table feeding a query feeding a form. The dbf is to collect improvement suggestions on a network from users. Suggestions can either be from an individual user or from a group of users. points are allocated to the individual (1) on entry. then if accepted, an extra 4 points is awarded...

firstly, ensure that the check boxes (all of them) in tools-startup are not clicked. Also have the default form you want to open first selected in the Display form bit of tools-startup then you can size the form and auto centre it making the boarders sizeable whilst you do this and then have no...

Private Sub Product_Type_NotInList(NewData As String, Response As Integer) Dim ctl As Control Dim strSQL As String ' Return Control object that points to combo box. Set ctl = Me.Product_Type ' Prompt user to verify they wish to add new value. If MsgBox("Product is...

you will need to goto tools - start up and select the switchboard from the drop down selection called "Display Form". this will now start your dbf with the switchboard. Not sure about the back up but you might want to consider creating a copy of the dbf, linking all the tables to the tables...

Firstly thanks for any input into this problem. I am sure that there is an easy solution (but only if you know how!) I have a form in which i would like 2 combo boxes to work from each other. In the first box i want the user to select from a list of 20 categories. then, based on the select...

Check that the DBF is opening in Exclusive mode and that there are no record locking set. To check these goto tools/options/advanced

Any ideas how I can place a command button on a form to search for user specified text from within all of the records the form relates to ???

use a cross-tab query (similar to a piviot table) experiment...

assuming that the forms info is based on a query (if not - make it so), type the following in the criteria line of the query field holding the date or month info [please type the month for analysis] then a box appears asking for the user to specify the month for analysis if you want to...

Thanks for that, I'll give it a go

Hi Mike, How do you select the printer for the individual reports? Are you using the docmd.select object code ??

I have encountered this problem myself. The way to 'Potentially' fix it is this... make sure that in the Tools\options\advanced, you have no record locking. Ensure that all the default opening status of the DBF is 'Exclusive' - check all users machines..there is a way to make each user...

using the docmd.runcommand.acprint makes the print dialogue box appear so you could choose your printer but would have to do this for each different printer. let me know if you find a better solution

Try using another field on the forms. Use code for the on exit or on change for the date field to say me.[counterfield] ="1" Then you can sum all the counter fields. make sure you call the counter fields a different name (counter1, counter2 e.t.c) to avoid confussion.

Thanks Guys, I have looked at the MS site and understand (I think) what they are saying. It seems that you have to pre specify the number of copies and which pages. I have also tried the Runcommand.printout method This works well if you want to print the form. What I need is to have...

Quick one? How do I get a parameter ? box to pop up asking how many copies I wish to print ???

Hi Mike, When I thought about it, I could use a autoexec macro so I wrote one to open, print and quit One problem. The Windows scheduler will open MS Access fine. When I ask it to open the particular file, the error log states that it cannot find the file specified. I am using the add...