Search results

I have a main form and a subform. In both I have the tab order arranged as I want. question: how can I go to the subform after I have tabbed through all my fields in my main form? When I reach the last field, Access brings me to a new (or next) record. I'm using Access 2000. Thanks! :)

Hi, I've been using Access 2000 and am having trouble with the report I want to create. I'd like to create a report that has two pages. For example: First page contains: Order ID, Customer name, Customer address, other customer info Second page contains: Product ID, product name, quantity...

You guys gave me an idea that it seems to work. In the form I'm opening from the main form I added the following statement to the "On Dirty" Event: Forms![frmCampaign]![dtUpdate] = Now() Simple, but it works. thanks!!!

OK. What if my form has a button that opens another form where the user inputs more info pertaining to that record? The before update event will only be fired if the main form is dirty but if the user goes back to that record and clicks on the button and fills out the other form, when going...

Great! thanks. :D

I'm using a form showing one record at a time. Is it possible to display to the user at the bottom of the form a textbox with info showing when that record was last updated (Date/time)? thanks!

Hey Pat, thanks so much! It works perfectly. :)

Hi there, I have a button on my main form to open a subform. I have in the subform's 'on open' event the following code: Private Sub Form_Open(Cancel As Integer) If IsNull(Me!CampaignID) Then Me!CampaignID = Forms![frmCampaign]![CampaignID] End If If Me!CampaignID = "0" Then...

Thanks Neil. You were right.. having the calculation done on the form works and it makes sense. Another question I have related to that is the following: My query looks for orders (and their totals) based on a "month" and "year" combo-boxes in my form. If I want to display not only the totals...

Humm... makes sense. I tried that however something strange is happening. The Total$ field in this query is in fact a sum (Sum Of Total$: Total$) and so I had in my query: Attainment: [Sum of Total$]/[Quota] but every time the query is run, it pops up a dialog box asking for Sum of Total$...

Hi! I have a database for sales orders with tables like: tblOrder tblRep tblRep-Order tblQuota tblRep-Quota Each sales rep is linked to an order (via tblRep-Order). Each rep also has a monthly quota (tblRe-Quota). Besides his/her quota, the tblRep-Quota also has a field for Attainment, that...

Thanks, Mile! It works. Strange thing this of the Date function not working.. one day it was fine, but today it just won't work... :)

Hi, I have a very simple line of code that is taking the date and adding it to a text box by using the Date function. However, the date that is being shown is not the current system date, but some other date. For example, instead of showing 04/22/2003 it shows 04/11/2003. I'm using the Now...

Hummm... what about when you ask Access to group weeks by month? like: Jannuary week1 Jannuary week2 Jannuary week3 Jannuary week4 Jannuary week5 February week1 February week2 etc.. How are those weeks grouped? Like, will Jan 2003 week 1 be from day 1 till day 7 or will it consider Mon through...

Great! Thanks.

Simple question: When using a report to group my data by week, how does Access calculates the weeks (1, 2, 3, 4, 5..)? thanks in advance! :)

Yes, setting the field as "required" will not solve my problem... maybe if I add some code to the "on focus" or "on click" event of the control? Any ideas? thanks!!!

Sorry, stupid question! I just realized that all I need is invert the order in which the target field receives the new text. :P

Simple and efficient!!! :) Is there a way I can add the new text before the existing one so the most recent is seen at the top? thanks.

Is there a way to, once the user tabs to a field in a form he can only proceed to the next one after entering data? And can I prevent the user from using the mouse in the form so he can only tab through the fields in the order I want? thanks!!!