Search results

I have searched the forum but seem to be missing something. I have a client table and several grant tables for different grants that each client can apply for. The tables are linked one to many. What i have is a Clients main form showing Refnum, Name, Address etc. What I want to do is have...

I am trying to change all the entrys in a table that contain 0's to 1's when a user clicks a check box on a form. I am using the code below but it keeps erroring can anyone help? Table is called tblChildren_Details and the Form is called frmBatch Private Sub Check12_Click() Dim...

I have a database which contains information about grant claimants. Grant applications come in all year round. I want the dbase users to be able to click a button which will generate a number for all those claimants who havent received their payment yet (ie put them into batches). I have a...

I have a pop-up activex calender which works perfectly. My problem is that when it opens, half the calender is hidden behind my subform. Can anyone tell me how I can get the calender to open at the front. There is no format option on the calender and I am not sure what the vb code should be...

:rolleyes: I am having a mental blank. I have a main form (parents and their grant applications) and a subform (children). The information for each is stored in three seperate tables. The parents and children are linked in the relationships via ParentID (one to many). The parents are...

I have search the forum but dont seem to be able to find the solution i am looking for. I am hoping its because it has a simple solution ....... I have a database which records grant applications for the current year. What i also have is a table which stores all the grant applications from...

What I have is a report which is grouped on Requested School, giving one page for each school. The report details pupils and what school year they are in. What I am trying to do is count how many pupils, for each individual school, are in each class year. The code I have used is below, it...

I have searched the forum for a couple of days and dont seem to be able to find the solution to my problem. Sorry if I have missed it. Anyway... On my form I have an option group for Accepting or Rejecting a request. The two options are saved as 1 and 2 in the table. I know that I can use...

I need some help!! I have a form which has a "search button" where users can look to see if a person is already entered on the database. The search button opens another "search form" which consists of a combo box at the top and a list of all people already on the database below. When a...

I have a form which has a combo box and a button which opens a report relevant to what is chosen from the combo box list. It all works very well if a user types the full name in the combo box or choses an item direct from the drop down list. The problem is if a user types in part of a word...

I have a check box which is ticked depending on the date in another field on the form. When a date [Post_EndDate] is entered into the field the check box [Current_Past] is ticked only if the date is in the future. The problem I am having is that I want the check box to update automatically...

I will try to keep this as simple as possible. I have a main form witch lists premises details. I have a subform which is displayed as a list of rooms on the main form. To edit or add information about rooms and users I have a command button opening an "edit subform". The mainform and both...

I have the following code on a close command button on a form:- MsgBox "Do you want to save this information?", vbYesNo If vbYes Then DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.Close Else DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveNo...

I have a main form which maximises on opening. The main form has a command button which opens a password form in 'restore' size. On entering the correct password another form opens. This all works perfectly. The problem I have is that when the password entry form opens the main form...

I have posted something similar to this before so sorry if I am repeating myself. I have an Option Group on a subform containing two options whose results are stored in the table as 1 and 2. I have a Dcount calculation in the footer of the subform counting the 1's and 2's, but I am getting...

I have am using Dcount on a subform, which counts the "1"'s in an underlying table. The "1"'s are created by checkboxes in an option group. The code counts the "1"'s ok, but I am unsure where to put a refresh/requery/recalc command so that the user doesnt have to close form and reopen to get...

I have an option group which gives the user the choice of whether a building is in use or not. The answers are stored in the table as 1 and 2. The subform, with the option group, has the record source as a query. I have tried to put the count calculation in the query but the subform wont then...

Am I loosing my mind?!? I have a form containing a subform, this subform is displayed as a continuous form. Ooooh simple so far... Now, when I change a date on the subform, it automatically ticks a box. This change is not displayed immediately unless I click on the relevant record on the...

I have a command button on a form, it opens a calendar from which the user choses a date. I want the user to be able to click the same command button to close the calendar. Is it possible or do I have to create another close calender button. If it is possible how is the code written? Thanks...

I actually have two problems!! 1. I want a check box to automatically be ticked if another field containing a date is in the future. I get this working but it only shows the ticks if I close the form and reopen it. I am a little confused as to which event to place the code in and where to...