Search results for query: *

I have 2 tables that I want to build a complex query off tblBadgeMemberDuplicates MemberID (PK) tblBadge MemberID (FK) DateOfIssue DateOfExpiry Each member has 2 badges in tblbadge, I want to filter 1 badge for each member, I want the badge to be the one with the highest date in the date of...

I have a form that gets its record sourse from a query when I try to update a record, it gives me the message "The Form is Read Only" Thanks in advance

I have a subform on a main form. I want to Filter the records shown in the subform The record sourse is tblMemALSSerRoster There is a field called MemALSSerAgreeTypeID which has 2 values 1 & 2 I have tried to use the following MemALSSerAgreeTypeID = '1' MemALSSerAgreeTypeID] = '1' (Do I...

I am adding the values in 2 sub reports Value 1 ([sbrptROCAttendances1/2].Report![txtAttendances1/2]/2) Value 2 ([sbrptROCAttendancesFull].[Report]![txtAttendancesFull]) The expression is...

I was getting the following message when I closed a file, Table 'TempMySysObjects' already exists I carried out the following tasks as directed by a rreply thread 1.Tools, Options, View - check Show System Objects. 2.In the db window, delete TempMySysObjects. 3.Tools, Options, View -...

I am getting the following message when I close a file, Table 'TempMySysObjects' already exists the file is set up to compact on close Thanks

I have a form that I want to be in the background invisible at all times. 'Me.Visible = False DoCmd.OpenForm "frmLHO", acNormal Thanks

I have a table called member attendance MemberID, Number Mon Boolean (Yes, No) Tues Boolean (Yes, No) Wed Boolean (Yes, No) Thurs Boolean (Yes, No) Fri Boolean (Yes, No) Sat Boolean (Yes, No) Sun Boolean (Yes, No) I then print a report off by date, example Tuesday 1st August. When...

I have a subform and I want to control the data displayed depending on a selection of combo boxes and list boxes on the main form. I am trying this code from a command box on the main form ___________________________________________________________ Private Sub Command17_Click() Dim...

I am using a command button and and option box with values 1 – 5 to view reports in print preview I added some error code to the “On No data” event to each of the reports. Private Sub Report_NoData(Cancel As Integer) MsgBox "No data found! Closing report." Cancel = True End Sub This...

I am trying to get a max value from a query and am using the following, any ideas why it is wrong =DMax("MemberID","qryNameDOBMAATs1") Thanks

I have a query that returns 2 records, each record has a field called memberid which is an integer. I want the query to return the highest memberid. am i correct in thinking i could use the min max function

I want to give the user a long message, the problem is that the line looks too long, how do I force some lines on to teh next line of Message. Thanks

I have 2 subform opening on the same form, on the load event of the main form I have included the following If Forms![frmEntryDup]![sbfrmMemDup].Form![MemberID] = Forms![frmEntryDup]![sbfrmBHDup].Form![MemberID] Then 'MsgBox "The PRIMARY key is identivcal in both forms. This form will...

I have 2 subforms on a subform. I am setting the tab order to go from a field to subform1, into another field, into subform 2 and into another field. The tab works perfect with the fields but it gets stuck in the first subform and won't come out. There is only 1 field in each subform.

I have a stand alone PC with an Access database file. I want the file to be backed up to a CD every 30 Mins. Do I need additional software.

I have an access file on a network, I want 2 users to be able to update the records at the same time. I have made the folder that the file is in writeable. This allows me to open the file on both machines. When I change record on 1 machine it is not reflected on the other machine. Does the file...

I am trying to share a database file over a network, I keep getting the above message. I need 2 users to be able to enter data at the same time on the same file, is it possible

I have a table with about 500 records, the table is used for mailing purposes only. There is a Yes/No Field which if ticked to true mean's the record is on the mailing list. I want to be able to save a selected list of records for future use. I thought I could do it with a make table query but...

why am I getting a Name Error DCount([MemberID], "tblMemFleetDiscount", "[MemberID] >=1)) Can somone explain when you do and don't use "[ and ). Thanks in Advance