Search results

Thankyou - I have applied this fix and so far the problem has not reappeared.

I have a report which is formated into 3 columns, very similar to address labels (though they are not) for some strange reason every now and again it seems to lose its format and reverts to having all the information down one side, I then have to go back into page set up and reset it all. I have...

Thanks for the reply. I managed to achieve what I wanted by using the table the text was transfered too as a temporary table then using vba I appended the fields I wanted to a permanent table and picked up the current main forms PK and appended that, then finaly deleted the records within the...

Is the field [bCalPh] a yes/no field? Then value for yes is -1 not YES

I am using the following code to transfer text Private Sub cmdImportSerials_Click() DoCmd.TransferText acImportFixed, "ImportSerial", "tblSerialNumber", Application.CurrentProject.Path & "\serial.txt", False Me.Refresh End Sub This works fine, the code is executed via a button on a form and...

This might not be what you want to hear but if users are constantly repeating the same imput errors then maybe you need to completley re-design the form to make it more user friendly. From your post I am not quite sure what exactly what the problem is, maybe it's just me having a bad brain day...

I have xp and whenever I have tried to set my reports to Pop Up and Module when hiding the database window as described here it never works. The Report loads hidden and I am left in situation I can only Ctrl-Alt-Del out of. The only thing I have been able to use with this method, that works is...

I've never heard of this before with XP, infact the exact opposite - one of the selling points of XP was that it could handle over 512mb of memory unlike 95, 98 and ME. If your motherboard can take that much memory and you are using XP it might be worth looking at other setting as you should...

NM shot in the dark, thought it might have been the WIN 9X problem with to much memory.

What version of windows are you using?

Yes should still work, I am though assuming that BloodPressureID is a record number and therfore the highest number will be the last record created.

Filter the query that feeds the report SELECT TOP 1 BloodPressureID, TodayDate, BloodPressure FROM tblBloodPressure ORDER BY BloodPressureID DESC; In the above query BloodPressureID is ordered Descending showing highest number first, then TOP 1 will show the first record only in the query...

me.checkboxname = true should that not be me.checkboxname = -1 or does True work as well?

Have you tried Window > Unhide

Set the control Source of the text box =([Unit Price]*[Quantity]) Set the Name of the text box to Line Total

Try this MsgBox (YourRs.Fields("StockTakeDate"))

The standard Tree View Control does not support a print method. Easiest way is to print the form it resides on or a more difficult solution would be to try and re-create the information in a seperate report.

Place the code in the OnTimer Event of the form Form Properties > Events > OnTimer Set Timer Interval to 600 and adjust as you feel Form Properties > Events > TimerInterval Or Use a pop up form instead of a message box ######### Edited ########### opps I must be tired thought I was in...

I can't see the point to using 2 tables, maybe you have another reason for this. There is also no need to store both the ParentID and ChildID. Just a ParentID, the highest tier parent in the tree will then be any record without a parent defined. I personally found this example a help. kb 209891

Maybe use the common dialog control to allow users to store the directory path to the document within a table is one thought. Maybe these 2 examples will help point you in the right direction. http://www.access-programmers.co.uk/forums/showthread.php?t=62414...