Many thanks both for your help. Problem now solved and so obvious :)
Jacc14
jacc14
Last Activity: Jul 18 '11, 11:21 AM
Joined: Jun 29 '07
Location:
-
How to prevent duplicate records after checking data?
Hi
When I enter a job number i have set up the following
...Code:Dim PID As String Dim stLinkCriteria As String Dim rsc As DAO.Recordset Set rsc = Me.RecordsetClone PID = Me.Jobnumber.Value stLinkCriteria = "[jobnUMBER]=" & "'" & PID & "'" 'Check JOB table for duplicate Number If DCount("jobnUMBER", "tbl_jobnumber", -
Thanks for this. Great idea. I will look tonight
Cheers
ChrisLeave a comment:
-
How to make a database expire
Hi
I would like to pass on a demo of my own database (MDE) for a customer. However I want to protect it so that after a few days it will expire so they cant use it again without actually buying it.
On the version I have , I have wrote in the code that after a certain date a message will appear to say it has expired and then it will automatically close. This is open to abuse however as if they are clever enough, if they... -
Result
Hi. Having explored further I have found a suggestion that i compile all the modules and remove any errors.
This has worked and I now have an mde file
Thanks
Jacc14Leave a comment:
-
How to create a MDE from access database
Hi
I am trying to create an MDE from my access database. However I get an error and it suggests that I probably have too many forms/reports as the database engine version 4 can only create a maximum of 2048 table ids at one time . However I only have 43 in total which i wouldnt think would be too many. Does anyone know how I can over come this without having to remove useful forms and reports.
Thanks
Jacc14 -
Thank you very much. works first time.
Best regards Christine.Leave a comment:
-
hi. I have done this but when I wish to open the form to add a new record I wish it to open as a blank form. It currently brings up the data from the first record in the table.
Thank You
ChristineLeave a comment:
-
Set Data Entry = False on form when opening
I have created a form and from the main menu I click a button and it opens my form so I can enter new records. The Data Entry is set to true so that i can do this.
I would like to use the same form later in the database to recall my entries and my using the following code I double click on a field (machine) and it should bring up my form which i can view.
...Code:Private Sub machine_DblClick(Cancel As Integer)
-
Dear Pat / Munkee
Result. I have dragged the figures in from the query. Thanks both for your assistance.
ChristineLeave a comment:
-
Hi There. thank you for this. Works perfect for my value field which is input direct into the table. However I intend to add a calculated field to my query and also sum this as well. This means it wont actual be a value held in the table. Is there anything similar i can do but from the query instead.
Thanks
Christine...Leave a comment:
-
Use requery to get total of a subform
Hi.
I have tried every avenue such as REQUERY, REPAINT, REFRESH but nothing seems to work. Basically i have a subform with a list of values. at the end of the list there is another subform with all these added together by doing a query to show the sum.
I have created a button which will refresh the totals subform when i want. However i dont want this as I want the totals to refresh everytime I add a new record ( I presume... -
Hi Jerry. thanks for taking the time. I can work with this.
Cheers
ChrisLeave a comment:
-
Hi Jerry. Yes the Start_time is in the sub form
best regards
ChrisLeave a comment:
-
Thank you Nic. Food for thought there. Looks like i will be getting the vba book out again but you have definitely given me something to think about.
best regards
Christine...Leave a comment:
-
Hi Nic. Thanks for the response and I see what you are getting at and it works as you have detailed. However the user would need to put in the start time which would automatically do the calculations. I am trying to find a way of the start times changing if I was to slot another job in.
Thanks for taking the time to respond
Kind regards
Christine.Leave a comment:
-
Hello Jerry. I think i spoke too soon. I have put the following code on current :-
This works but the moment I start to enter a new line it just blanks out the defaultvalue as its looking at the current line. I basically want to set it and it then not change again if I move around...Code:Start_Time.DefaultValue = """" & DateAdd("n", 0, Me.PlannedfinishTimesplit) & """"Leave a comment:
-
Hi Jerry. You are right the Start_time is a control on the form. I have tried your suggestion with OnCurrent and success.
Thank you so much
Jacc14...Leave a comment:
-
Inserting records and re-sorting
I have created a subform that you enter details of a job to be run on a machine. By entering a date and time it calculates the expected finish time using the amount the machine can produce in an hour and the quantity required. This works well.
However I have been told that sometimes the user may wish to slot something in the day which would mean once they had typed the details in, they then have to manually adjust all the start times... -
setting default values
I am working on setting a default time when a form is opened.
This is working as it should but i have set a bound text box to select a different machine to get a different list. When a different...Code:DoCmd.GoToRecord acActiveDataObject, , acLast Start_Time.DefaultValue = """" & DateAdd("n", 0, Me.PlannedfinishTimesplit) & """"
No activity results to display
Leave a comment: