Search results

I have two forms. Form one, based on a query Form two, based on specific record said query When form two closes I would like form one to refresh with any changes made to the table/record and update itself. Any advice.

I have 2 tables like so: 1: ID Name NIID* 2: ID* NAME My form is based on Table 1, and has a combo box linked to the NIID field. I whish the drop down to displace the records table 2 and once selected his name to appear as the text in the combo box. Is that doable and how?

Hello, I have two tables. One is a list of clients and the second is for update notes. Each client may have several notes (one to many relationship). What I want is a query that will show each client and there most resent update... but still show the client even if they have no update. When I...

Hello, I have a form that opens up a record for the user to view and edit. I would like the form to have a save and cancel button. The save button is fairly simple, save the record and close the form. I have struggling with the cancel button vba though. I want it to first, discount any...

I have one form that has a listbox showing the results of a filter, which works fine. The list box has a doubleclick event that I want to open a form and then find a record on the form. I tried to following but it does not work. Any advice? With Forms!frmEmployerView.RecordsetClone...

Can someone explain briefly how multiuser access works in access. I have a database fe and be. The fe has forms and stuff. The thing is I do not want a user to be able to edit a record while another user is view it. Is this automatic or can I make it so?

Hello, My goal is to have a database with two tables and a form. The tables will be linked. The first table with have a field titled "Number of Positions" the table linked to it will be people that have positions. there will be a field in the first table titled "Number of positions remaining"...

Hello, Please can somebody advise me on the best way to count entries in a field to display on a report. The entries will not be known in advance so I need something that initially grabs the unique entries from a field and then performs a count on each of them. Regards,

Is there anyway to open the default web browser and navigate to a page (much like a standard hyper-link) in VBA?

Hello, I am creating a task management section of my client management database. When I create a task I would like set the due date with a buttons, for example, due tomorrow, due in 2 days. One button I would like to set the date to Friday of the current week. Any idea's how I would do this in...

Issue with Access 2007 Biult-in Themes Hello, For some reason when I apply one of the built-in 2007 themes to my forms they no longer include the picture in the form header, it just changes the colour and control formatting. Any Idea's? Regards,

Hi I am really new to vb.net database programming so bear with ;) I have made a simple front end displaying data from an access table. I want the user to be able to locate the file using a dialog however as the access file could be anywhere on the computer. I have created a menu strip that...

Hello, I have a split form (picture attached), I want to create a text box that will filter the information. I have tried binding the splitform to a query, with criteria based on the value of the text box, then creating a re-query event when a key is pressed in the textbox. This works for...

I want to create join between 2 tables. One is a list of Assessors just ID and Names. The second is a list of NVQs. I want the database to know which Assessors are qualified to assess which NVQs. So for example when i got to Joe Bloggs' Record it will show the NVQs he can assess (example: CS...

Hello, When I make a database I have done into an MDE one of the forms no longer works and gives the error "Can't perform operation since the project is protected." Here is the code behind the control (a button) that does not work. Any idea's why? It works fine before protecting the form...

I have a form with text boxes (I'm great I know) However they are often locking up (cannot get focus and type in them), it seems if i click on some other text boxes then click back in the locked up one it lets me in... not sure what the issue is. Any idea what it could be? It does not happen...

Can anyone help me find the date the Monday of the current would be? I can find the date using.... well date(), but then how would I find the date of monday from this week? Many thanks for any responses Regards,

Hello, I have a series of text boxes on a form with the expressions like this: =DCount("[UID]","[qTesting]","[Test Subject]='Numeracy' And [Test Level]='Entry Level' and [Passed]=Yes") So the role of the text box is to, check the query for Numeracy tests at Entry Level that have been passed...

Hello I have a report based on a Query. I want the criteria be based on two text/combo boxes that allow the user to select the month and year. So the if the user selected January and 2009 I want the query to show entries for that month only. Any tips? Many thanks!

Hello, Okay scratch that, I going to explain it differently below. Kind Regards,