Search results

Boblarson Thanks, I used Dmax as follows, & it retreived the maximum number; =DMax("[MyField]","[MyTable]") Note that I didn't add one to the above because I was just testing things at this stage. The problem I now have is that because these physical paper forms are in booklets they only follow...

CyberLynx Thanks for your help. I tried your suggestion but it returnes a value of 1 & not the last enteres number, as desired. Note that I don't want the table ID, but the ID of my physical written form, in this case the field has a name of DecNumber. I might have confused you in my first post.

Hi all, it's been a while since I have done anything to my db's in Access so I'm a little rusty. I have a sub form with a Field, in which I enter ID's taken from physical forms(paper forms). The ID's are in booklets with increasing order throughout each booklet. I want to have MyField show the...

You could try using a button plus a label, with the label directly over the button, then using the On Mouse Move event you can get something like you want. Do a search on mouse move or buttons.

Thanks ChrisO that's just what I wanted. About 10-20 is ideal for me.;)

I am using something similar to the following in report & a module to draw a elipse around a field. I want to increase the thickness of the line but have had problems. I've fiddled with drawwidth without success. Any suggestions? Private Sub Detail_Format(ByRef intCancel As Integer, _ ByRef...

BobLarson Thanks for your reply. I thought I'd checked & set my Sorting & Grouping preferences but after your suggestion I discovered that I probably hadn't saved my report when I made the original changes. Now it's set & working ok, thank you.;)

I've been trying to get a report to open up at the last or latest record. Initially I thought all I needed to do was sort the query date field or ID (auto numbers) in descensing order but that doesn't work. The query will sort ok but the report will only open up at the first record. I have a few...

Put this in the form's BeforeUpdate Event. Each time you change data on your form it should fire up & ask you if you want to save the record (data). Good luck. If MsgBox("Save Record Now?", vbYesNo, "Confirm Save") = vbYes Then Else Me.Undo End If

Soon I'll be starting a new DB which will be used to issue receipts to people who attend courses run by a business. I don't want or need it to be very complicated so was thinking a something like the following; TblClient (ID,client name & address fields) TblCourse (ID,Date, course name & Price...

A simple way is to use the following in a New Query Column (just add it at the end of your querie's normal columns & set the criteria for the new column to True; [YourDateField] Between [Forms]![YourUnboundForm]![txtStart] And [Forms]![YourUnboundForm]![txtEnd] Or...

I have used the following in the OnPrint event in the Detail section of numerous reports. You can easily fiddle with the numbers to get your prefered colours. Colours in this example are very pale because I don't want to use excess ink or toner when I print the reports but they are sufficient to...

I opened this db and had a look at it, entered a few numbers & closed it then I had to login to access & didn't know the password! Be warned if you test this (fiddle) you might set a login for access which prevents access to MSAccess. That's what happened to me. I had to search out the file...

OSB Thank you, I edited text18 (had wrong one to begin with) as you suggested & the calendar report is working ok. Im still having problems with the Calendar Form and it is something to do with the second wednesday of any month?? Even if data is written it is not possible to view it in the...

OSB I'm refering to your earlier (simpler) version of the calendar with nice yellow & green background colours in the calendar form, not the version with multiple entries per day. If you look at 12th July 2006, or better still enter some text for that date, the result, on 12th July 06, when...

OSB I just had a look at your edits fo the basic form & you have done a great job, well done. I noticed that in the Current Month calendar report any wednesdays on the third line in the report have #name? showing & the corresponding day in the calendar form I couldn't delete any text I had...

Lately I have been using my db's on computers which did not create them (my db's). I've been seeing this message sometimes; Microsoft Access You have modified a signed project. you do not have the correct key to sign this project. the signature will be discarded. can someone point me in the...

Thanks Doc. How do I make sure i am the DB administrator for Access?:confused:

I'm changong computers and at prestne (for a few days) I am using a borrowed computer. When I edit any of my db's I now get a message telling me that I haven't got permission do carry out what I am doing & the permissions will be erased (can't remember exact message cause I'm on another...

There is a "Buttons" button on the toolbar which will do what you want in a few seconds. Drag the button symbol to where you want it & select your report in the menu (pops up automatically). After that click "next" a few times & you have a command button to your report(created by the wizard)...