Search results

Tambo, After looking at the database you attached, you are basically there, all you need to do is add the code to the buttons on your new record form. For example: Me.Text55 = GetOpenFile(Me.Text55) This calls the GetOpenFile function in the module you have created, which opens the...

Since you say "central network folder" I assume you only need to implement a browse button, that will return the full path including the file name of the document that the user 'browses' to. I have been using a module that uses Windows/Office API calls to enable a whole bunch of different file...

You could call the aggregated query from the UPDATE query using DLookup. UPDATE Summary AS s SET s.amount = DLookup("SumOfAmount","qryDetailsSum","refno=" & s.refno & ") Which uses a new query qryDetailsSum SELECT d.refno, SUM(d.amount) AS SumOfamount FROM Details d GROUP BY d.refno

To stop seeing this popup, you need to set the security level in Word to Low (Tools\Macro\Security). But be warned, the message is there for a reason, never open files from sources that you do not trust.

Another thing to remember is that you don't have to do all the processing and calculations when the data is being received by the RFID mat. If you simply record all the data in your table you can create queries to select the last recorded input for a given competitor. So basically you could...

Ouch, I hope that's not 24 hours of constant exercise, that just sounds far too much like hard work:)

Yes, I placed a textbox on the form called txtRecordID, with the Control Source set to the RecordID field.

You may need to rethink storing one global variable 'starttime' in the stiuation where you need to provide waves/staggered starts. I suspect you would need to store both the wave name, such as 'Professional Male' and the actual start time in a table. My suggestion would be to use a sub form...

I assume your form is a continuous form showing all the research papers so that you have the RecordID field available to use. You can then have a 'Add to Favourites' button on each record, that when clicked calls some code to add that record into the third table, along with the Logon value...

Just a few thoughts. If you record different start times for all competitors - as I gather from reading your post - could you not end up with the situation that someone who actually crossed the start line late could have a better time than the winner? For example, what if I wait for the gun to...

What error do you receive? Put a breakpoint in your code to make sure the value of [Fund Number] is being sent in the DLookup. Also are you sure [Fund Number] is a number, not text? The other point I need to make, which I know Brian made earier, is that you need to stop naming the controls...

What does your query return? You do not explain how the query knows which records to return, or does it only return one row of records? As Brian suggested, have a look at the Access help file for DLookup, it will tell you exactly how to set up this code. It also has some great examples to help...

Hi again, I have modified and attached a copy of you database that has code that will hopefully achieve what you require. Firstly, when the form opens, use the On_Current event to enable all the required fields. Private Sub Form_Current() 'enable all fields required Me.Option62.Locked =...

I was able to recreate the error when using dates early in the month, for example using 6th Feb 2009 (06/02/2009), I also got 2nd June 2009 (02/06/2009). In the past I have been able to tweak these kind of this by splitting the date into its various parts as shown in the code below. This might...

I could not reproduce the date format switching. I have mine set to dd/mm/yyyy and when I use the code you have, the new record has dd/mm/yyyy also. Where are you placing the code? I tested using a button that also created the new record. My full code is below: Private Sub Command4_Click()...

Data from SQL server can be retreived via ODBC directly into Access, if this suits your requirements. Then you can create reports to your hearts content with the bonus of have 'live' data, not even one hour old. I routinely link tables from SQL Server so that I can utilise the great reporting...

I tested your code but couldn't get the same result, but to force to format of you default dates you could try; MLEARN_ID.DefaultValue = Me.MLEARN_ID NORVW.DefaultValue = Me.NORVW + 1 PRVRVW.DefaultValue = Format("#" & Me.ACTRVW & "#", "dd/MM/yyyy")

Reiterating Brian's comments and using your previous code, I have assumed you have two(2) textbox controls on you form. One named "Soonest Value Date" and "Value Date". You can use the Value Date LostFocus event or After_Update event to lock the Soonest Value Date field. Private Sub...

The error message "The value you entered isn't valid for this field" points to your problem. You are trying to store the string "SVD" in a field that has a data type for Date/Time? If you want to store a value in the field [Soonest Value Date] then you need to modify your code to; If...

You will need to provide details of the as the database you attached only has one table. If you need to return the value from that table, you enclose the field name in square brackets in your IIF statement. For example the code below returns the value in the field named Soonest Value Date...