Hi, I already have my tables set up, I was just wondering if it may be a good idea to dump individual jobs to their own tables and not keep them all in one large results table. I suppose I could just generate a report and email that or a link to it to the customer.
My main reason for the question is because I am planning to move this project from access to a standalone vb app.
Tables I have are.
TEST SYSTEM STRUCTURE...
malcolmk
Last Activity: Feb 18 '14, 05:48 PM
Joined: Sep 3 '10
Location: united kingdom
-
should I give each job result its own table?
Hi, I am planning a test request, process and report system. It goes like this, a customer requests a set of tests to be carried out on a particular item; the tests may be medical or mechanical or anything else. The point is each request is given a job number and each job number may contain a request for many tests.
Instead of a table containing many entries of job numbers
ie.
job 001 test1 result
job 001 test2 result... -
I beleive that setting the row width in the combobox property has no bearing on the size of the combobox on the form. You can adjust width on the form to show only company name, when clicked the drop down can be the whole width of the screen if you want up to a maximum width of 22 cm.Leave a comment:
-
why not simple tie the listbox to a query to retrieve ONLY overdue tasks.Leave a comment:
-
How are you selecting the records to allow edit on? If you persue my idea above then you need to have some method of putting the record id into an array. Are you planning to select records from a dropdown box? If i work on some code then I must know from where on the main form I get the record id for edit? or maybe the records to allow edit are defined elsewhere?Leave a comment:
-
Try using the on exit event of the ach field to test values for ach and refund fields, open form accordingly.Leave a comment:
-
Presumably you can cycle through the records on the subform? Why not place the record numbers to edit in an array then in the subform oncurrent event (tells you which record is displayed) use code to enable editing or not depending on if the current record matches a record number in your array.Leave a comment:
-
Forms and subforms reference here http://www.mvps.org/access/forms/frm0031.htmLeave a comment:
-
could try http://www.mvps.org/access/forms/frm0031.htm try google it will throw up all sorts of usefull sites.Leave a comment:
-
Look into using the forms oncurrent event to enable or disable your button.First on form open event I would
Now in the forms oncurrent event test to see if at first or last record and enable or disable your button accordingly....Code:public last as long DoCmd.GoToRecord , , acLast last= me.currentrecord 'that gives you the last record number DoCmd.GoToRecord , , acFirst 'go back to first record
Leave a comment:
-
yes buy 2002 or 2003. Just be sure when you save your work to save it in 2000 format from the file menu.Leave a comment:
-
php and mysql spring to mind, store names in mysql table, generate pages with php.Leave a comment:
-
You just need to insert the code you want for the condition Vbyes or Vbno.
Code:Private Sub Command0_Click() Dim x As Integer x = MsgBox("are you sure you want to cancel", vbYesNo) If x = vbNo Then x = MsgBox("ok don't cancel", vbOKOnly) Else x = MsgBox("ok cancelling operation as requested", vbOKOnly) End If End SubLeave a comment:
-
Why not just create two queries in the query wizard, one to show events and one to show payments?
Wizard is easiest for simple queries I think.Leave a comment:
-
Ok have stripped my old app except for relevant code.
First off let me point out a few things.
When the app starts it may ask you if you want to block unsafe expressions, the only way I know to get around this is to go to te tools menu in access and select macros, security. You need to set the option to low which, I guess is ok if you are operating in a closed environment. Or add yourself as a trusted source but I don't know how to...Last edited by malcolmk; Jan 14 '11, 01:36 PM. Reason: forgot attachment aahhh left application.quit in switchboard exit routine so can't edit form, removed and re-upped.Leave a comment:
-
OOps, just taken another look at compliling database to mde and using access runtime module, still allows user to access tables so sorry no good.
Will dig out an old prog of mine with code to disable menus etc and post soon as.Leave a comment:
-
You can compile the access app so it runs independant of access or you can switch off all the background stuff from within access code. No need to reinvent the wheel.Leave a comment:
-
I take exception to the peasant comment Lysander,( hopefully it was meant in jest rather than a putdown ), it is in my experience of working life (some 30+ years) the peasant who knows the full story of just exactly what the job function entails. Most management have the attitude of, I want that over there and this somewhere else but don't have a clue as to what resources are needed to accomplish it and more importantly of any detrimental knockon...Leave a comment:
-
In original post Jackie it seems to me that you are simply overwriting the form filter command in the second function call, what you need to do is combine the two required filters into one. Result of sub frame29 plus result of sub frame38.
ADezii has given you most of the code so just follow it through logically or modify your original code.Leave a comment:
-
Depending on exactly what you want to track then the tracking table could become huge.
the way I would go about it is to have every user login with a unique id, have a table called tracking with fields somewhat like Userid( obviously the user logged in ) When(date and time)Formname(n ame of form accessed by user) Operation( values of viewed, edit,add,delete ,recordnum,fiel d)
Each time a form is opened, record edited, deleted, added the...Leave a comment:
No activity results to display
Leave a comment: