Search results for query: *

I use the following code to stop users from entering a date on a record when that date has already been used in another record: If Not IsNull(DLookup("[ActivityDate]", "[tblActivitySheet]", "[ActivityDate]=#" & Format([ActivityDate], "yyyy-mm-dd") & "#")) Then MsgBox "There is already an...

For instance... Law offices of...etc Dr. so and so How would you approach sorting for search tables and combo boxes etc... Just a programming problem that I am sure is quite normal. Thanks for any articles you may be able to point me at on this topic.

I have a subform that is datasheet view. It is activities for an order. I want users to be able to delete/edit these activities as needed accept for certain activities. Most are fine, however, if the ActivityCode is "WE" (Work Order Entered), then I dont ever want that to be edited or deleted by...

I need some advice here. What is the best way for Access to tell whether an updated record is a new record, or a record that I just edited. For instance, if I am entering a new order, and after that order updates I will have Access automatically do something with part of the data...however, if...

I know this has to be very simple, however, I can't figure it out. I need a command button that changes my form view from single form to continuous form. I know how to change a subform view to datasheet, but I can't figure this one out. Help please.

Is there a way to Disable the tabs on a TabControl until my criteria has been met? Here's what I want to do. There are a few tabs, and I want to force users to enter the data in the tab order I designate. Once the criteria is met...ie...mandatory fields are filled...then the next tab is...

Can somebody please help me with this. How can I have a message break into two lines using the Access Message Dialog Box? Some of my messages are detailed and real long: MsgBox "Blah Blah Blah extra long message", vbCritical I tried this without success...maybe somebody can fix this for me...

I got a lot of help from PHV on this originally thread702-1374042. But I am stuck now. I use the following to transfer data from one record in a subform to another. The subform is "singleform". And I use a command button if I want the same data transferred to the new record as follows: OnClick...

Last one for the weekend... I have a field on a form "Documents Filed"... I have a list of the most common docs used in a list that is a pop-up form. On that list I want to double-click the document that I want added to the "Documents Filed" field in my main form. I know how to do this where...

I am having a tough time with my limited knowledge of VB on transferring data to the next record. Here goes... I have a subform that is set to "Single Form". I have a command button on that subform that is a basic DoCmd.GoToRecord , , acNewRec. The subform is Locations for an Order. The...

I have a form that has an unbound text box on it that I want to limit the number of characters to. I want it to just stop at 310 characters and not let anymore be added. Can I get some help please?

I have a report that is a Work Order. Everytime the work order is printed I would like to add some "Special Instructions" to it. However, I don't want the instructions being saved in the database as a field in a table, I just want them to print on the Work Order. The same work order may get...

I have a query I use to locate a customer by entering 1 or more letters in a parameter as follows. My question is, when the user just hits enter without entering a parameter it will bring up every customer. This is well over a 100,000 records. I would like the query to bring up nothing, or be...

I use the following DLooUp string on a form to show the company name from the Customers table after I enter an account number on my "Order Form". For some reason the Company Name text box shows as an "Error" until I add the account number. Shouldn't that just be blank until I enter an account...

Is there a way to do that. I want to set up an envelope report that spits out an envelope from data in my database

I have a form that has a command button on it to email the report in SnapShot Format, Is there a way to rename the report that I am sending. Specifically I would love to name the report by what Order Number it is.

How can I get the Page header to show only on the first page, and Page footer to show only on the last page? My report is a letter and will sometimes be long enough to go multiple pages. Report footer doesn't show all the way to the bottom, so that doesn't work.

I need help on emailig a report using .rtf Format. This is not working for me... DoCmd.SendObject acSendReport, "rpt_SkipTraceComplete", acFormatRTF...etc Please help!

I have a filter I am using on a form. I am not very savoy with sql, but I am sure the problem with the following string is that "ActivityDetailsID" is a text property. Can somebody help me change this please? Thank you. strFilter = "ActivityDetailsID = " & Me!ActivityDetailsID

How can I go about numbering the items in the detail section of a report next to the item. I want it to look like this: (1) Butter (2) Milk (3) Bread Hopefully that explains what I want. Thank you in advance