Search results

Hi What about doing a query that identifies any records where your alert conditions apply. Then build a form based on that query to show the details of the problem lines (may be more than one so make it a continuous form). Now put in something along the lines of varAlert = DCount("a field"...

OK Perhaps you would be quickest just using scroll. It may be easier than getting into VBA coding behind forms unless you fancy learning it. If you are planning to use Access much you will need to sooner or later. Lots of good advice if you search the forum Good luck

Sounds like you simply need to be patient and line up all the controls manually till they are about right. Then try selecting but watch very carefully what is selected and make sure you save before you align. I seem to recall this happening to me once but cannot for the life of me remember why...

If they are all vaguely in a row or column you can click at the edge of the form in design view and highlight the column or row. Works well

Hi Highlight the controls you want to align. If looking for a vertical alignment (i.e. a column) you use align left, if a row, you use align top. To get spacing even click on Format, Vertical Spacing, then make even and then increase or decrease as needed HTH

Hi You can use the MoveSize function in VBA In the code on the button you use to open the form, or in the OnOpen event of the form you use (for instance) DoCmd.MoveSize 0, 0, 14500, 6500 That will put the top left hand corner of the form at the top left hand corner of the screen and give you a...

Hi You need to look at using one table that can have muliple entries for the size grades e.g. ID SizeGrade Product 1 1 1 2 1 2 3 1 3 4 2 1 5 2 2 etcetera This way you can use queries to show all products for SizeGrade 1 or...

Thanks guys I ended up trying System Restore and whilst it has given me a few registry issues it does seem to have resolved the keyboard issue. Will play with it today and see how it goes. If still issues then I will do the reformat and reinstall. Thanks again for the help Best wishes

Hi Minkey I tried as you suggested. It works in BIOS - there was an event saying POST ERROR - keyboard but it didn't give any more details. Then I tried it in safe mode but the keyboard wouldn't do anything. I have found a Dell diagnostics CD and ran the keyboard test on that and it came out...

Thanks Will try but it will have to wait till tomorrow I will let you know Best wishes

Hi I have acquired a not terribly old Dell PC that was tossed out because keyboard not working. I thought (trying to be clever) try out a USB keyboard so I bought one and lo and behold it doesn't work either. It seems to be recognised in Device Manager but hitting any key results in a wee bleep...

DateDiff("d", [MyDate], Date()) You may have to play with the sequence (if it comes out - then reverse the two) and I think number of days is "d" but if not try Access Help on datediff. Hope this helps Good luck

Try DMax on the date field in a query to identify the most recent record. You might need to set up a query to get the price. Hope this helps Good luck

Hi Have you tried <Tools> <Options> <General> and looking at the default database folder. You need to have the database open to get to it. This might do the trick Good luck

Hi I have tried searching but to no avail. I needto be able to identify consecutive dates in order to group sickness periods together. I then need to count them so that if the total is <28 it counts as short term sick and if >28 as long term sick. Records will be in an SQL table Timesheet, and...

Hi What the DLookup is doing is seeing if the password entered on your form matches the password recorded for the user (also named on the form). i.e. password on form = password on database where user on form = user on record. Can you post the actual code you have put up so I can see?

OK Pehaps worth commenting out the lines of code under the sections that record the user and log the event since you probably don't have these tables set up - simply put a ' at the beginning of each line If still a problem then put a breakpoint on the "If then" line and work through the code...

My code refers to specific tables and field names. You will either have to re-create in your db or modify the references to suit your db. Does that help?

Hi Here is simple code I use. It seems to provide enough security and logging for most of my applications but could probably be improved upon Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim stDocName As String Dim stLinkCriteria As String 'Check to see if data is...

Thanks Rural Guy That was it. I thought it needed both belt and braces but I was wrong. Works fine now. Do you stay at 8000' or go up into hills?