Search results

I am trying to make a simple operation in a report with elements from 3 different sub-reports. It looks like this: =([qryQuotationalSavingsReport subreport].[Report]![Saving])+([qryAuditSavingsReport subreport].[Report]![Saving])+([qryRejectionSavingsRep subreport].[Report]![Savings])...

I am trying to apply a criteria on a query with a list of dates. I want to extract the year from a form and I want to see the dates for that year on the query results. I am trying in the criteria for the date: Year([Forms]![Main Menu]![DatSav1]) The query results are empty.

Hi all, I have a query (qrySAV) with 2 components A and B. I want to create a new one "C" in which If A>0, C=A, if not, C=B I have tried: IIF ([qrySAV]![A]>0;[qrySAV]![A];[qrySAV]![B]) I am not sure if it is necesary to refer to qrySAV when the elements are in the actual query. When I...

I have 3 tables: *Members (MemberID) *Cases (CaseID, MemberID) *Activities (ActivityID, CaseID) I am trying to do a query to see a count of cases and activities by members. When I do Members->Cases(count) I get the correct results for nr of cases: Member 1, 19 cases When I try to add...

Dear all I have a query in a protected access DB that I need to import into excel. I've searched the forum and on the internet, but I couldn't find a comprehensive answer explaining how to do it. I know how to import the query from a non-encrypted db. Thanks

Hi All, I have a Form "Activities" and another one "Customers" I would like to trigger an action to auto-populate an "Activity" on all "Customers" that meet a specific criteria (I can get the list of these on a simple query). Is this possible with VBA? Could someone point me on the right...

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?

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...

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...

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...

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]...

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

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=...

Hi all, Is it possible to generate a link to a report (associated to the respective ID) on query results?

I have a table in excel that's a query coming from an access db. I created a couple of columns at the end for different calculations and I am having troubles with the results since those matching a condition are not formated as "date" like the others. My function is...

Dear all, I have a DB with a linked excel spreadsheet. It is used to auto-populate different fields on a form. The database is split and when more than one user are working on the same form, we get the error: "The MS Access database engine cannot open or write to the file G:\myfile.xlsx. It...

Dear all, I am getting this error on the below VB for a button that should create a folder and place a PDF of a report in it. The code is working on another report created previously and I just updated the FilePath and FileName. It creates the folder correctly, but I get the OutputTo error...

Hi all, Is it possible to not showing a specific field in a report based on a query if a checkbox in the same query is active?

Hi all, Very basic question here. I need both to have a calculated field in a form and register the result in its table. The calculation function needs to be placed in the Control Source, right? How can I select then in which field the result must be registered? Should I just do the same...