Search results

Done and I get the same error, the format in the control is "General Date"

I'm trying to use a button to record the actual date and time on a field on my form. I'm using simple vba (below) but I am getting an error (see attached). Private Sub Now_Click() Me.CreatedOn.SetFocus Me.CreatedOn = Now() End Sub The field on the table is formated as "General Date" and I am...

Is there any issue is using the same query as a record source for 2 different subforms that are to be open at the same time?

I think that I found the problem. The Data Entry property on the form was set to "Yes" :banghead:

Thank you! Unfortunately it didn't make the trick for me. I get the same result..

Hi all, Somehow I managed to save 3 of my forms with a filter on it that I can't remove now. As you can see on the uploaded pics, the "No filter" on the record selector is greyed out and on the form properties, there is no filter applied. The Record Source for the form is a table, not a...

That was exactly the problem! You rock! Thanks a lot!

There is one thing that I find weird. When I open frmClaims, instead of having access to all the records, there is only one. All the claims are there when I open the table, but opening the form, there is only a blank form with no access to browse all records. This might have something to do with...

Thanks!I get the error "MA can't find the field 'frmClaimList' referred to in your expression" "frmClaimList" is a subform in "frmMemberDB", that's taken into consideration in your expression. right?

Private Sub Name_PrimaryICDCode__Click() On Error GoTo Name_PrimaryICDCode__Click_Err DoCmd.OpenForm "frmClaims", acNormal, "", "[ClaimID]=[Forms]![frmMemberDB]![frmClaimsList].[Form]![ClaimID]", , acNormal Name_PrimaryICDCode__Click_Exit: Exit Sub Name_PrimaryICDCode__Click_Err...

I was using the following Openform macro to go to a specific record from a subform: [ClaimID]=[Forms]![frmMemberDB]![frmClaimsList].[Form]![ClaimID] suddenly it is not working and it is taking me to a new record on the target form. Could somebody let me know the correct GoToRecord syntaxis...

Because I'm a newby. Thank you so much. This makes my life so much easier.

Hi all, I've been using the following code to copy a [MemberID] and paste it in another form on a [MemberID] field when pressing a button. I'm suddenly getting the error in the title and I have no idea why. It had been working with no problems so far. Private Sub btnNewCase_Click() If...

Thanks! When you say "Create you own form with the tabs on it", can I use the object Design>Navigation Control? I still fail to refer to an object from tab to tab. I have some members details with a MemberID in a tab and I need on a second tab to get the MemberID from the first one when I...

I am trying to understand the navigation forms. I have 2 forms [fromMemberDB] and [frmCases] I have dragged and dropped these 2 forms into a Navigation form [frmMemberNav]and I can switch between the 2 with the tabs. In [fromMemberDB] there is a field called "MemberID" and in [frmCases]...

Guys, I think that I need to take a step back and ask for some advice on how to set this up. I have a list of members that will have claims. Under every claim can be one or more invoices. What would be the right way to do this? What I am thinking is either *A subform on the claim form with...

Dear all, Could someone help me to write the VBA for a button in a form (form A) that contains: [MemberID] and other fields, that opens a formB with the MemberID=MemberID (of formA) filled in? Thank you in advance

It was that! Thanks!

I am trying to make a simple calculation on VBA and I am missing something. I need on my form that when I click a button it calculates the 15% of a field and place the result on another one. I created a button with this code: Private Sub Command543_Click() Me.QuoteApproved=...

Thank you very much for your comprehensive answer, Pat.