Search results

Hi, Not sure about the immediate window you referred to, but each time i get the error i am taken to the vb window where the D Count Function is highlighted in yellow. And the other thing am not sure whether the control source of the cboVenue is causing this, since its control source is based...

Hi spikepl, I tried that but I got the same error : "Type mismatch" Please, have a look at attached copy of my project file if you have time. The form I am using to add data is F_Training_Programmes_Add. You might open the form F_Training_Programmes_Running To get an already existing record...

Hi, I am trying to use a DCount Function to prevent users from creating duplicate records, but i am getting a type mismatch error. The function is as follows: - Private Sub Form_BeforeInsert(Cancel As Integer) If DCount("*", "[T_Training_Programmes]", "[Programme Name] = '" &...

Thank you Banana, I am going ahead. Stay well

Hi, I have successfully installed and configured MySQL on one of my PCs is connected on a LAN. My intention is to create new user accounts from the other PCs on the same LAN so that they can access the database(s). I will be using MS Access as front end. What I would like to know is, after...

Hi Taruz, I put your code in the afterupdate event of the combobox but got error "Invalid use of the property" .Column

Hi, I am attempting to capture accesslevel value into a txtAccesslevel on a login form when the user updates the cboUserName combo box. Hence, in the afterupdate even of the user combo box i have the following dlookup function: Me.txtAccessLevel = DLookup("userAccessLevel", "tblUsers"...

Hi Jonathan, I have attached a striped copy of my project. The form with the controls I mentioned is "F_Daily_Incidents_add." I appreciate. josephbupe

Hi Jonathan, I appreciate your help and especially on handling the chk controls. As for the investigators, you may wish to know that actually there is a table called "tblUsers" and both the users and administrators are stored in this same table. Essentially, what i want is a way to...

Please, I need your help. I have a form with a few controls in it. One of the controls is a combo box (cboInvestigator) where the database administrator(s) can select the investigator;hence, assigning the current case to him/her. Initially, the case would have been assigned by default to...

Hi, I want to create a command button with an on-click even. I am wondering if I can run a fully functional DAP database that can open other dap pages on click of the command buttons offline. I have tried the code below nothing happened: <SCRIPT language=vbscript event=onclick...

Please, open the form "F_Training_Main" I am having some problem when, for instance, i query for "South Africa" as a Venue, initially that will return three records, click "Search" button again will return nothing, click "Search" again will return several records. The same thing happens...

Thanx for your responses. As to for what purpose I am attempting to open .txt documents? Well, it is a system for tracking criminal cases associated with theft of motor vehicles. Each record has a txt file I want associated to it. In a nut shell, for the same purpose as explained at...

Hi, I am attempting to open .txt files (with a notepad) from access following the hint at http://www.databasedev.co.uk/open_word_doc.html But, I am getting an error "ActiveX component cant create object", which is taking me to the line in the module Set objApp =...

Please, I need to modify this query in the AfterUpdate event so that it can search on multiple fields in a table. Currently I only have one field LastName on which it is querying and I want to extend it so that it includes fields: FirstName, OtherNames and PassportNo. If Me.txtSearch.Value...

Hi, I do not know much about treeviews, but having looked at many treeview samples posted on this site and elsewhere on the net, I came across this sample, which I think suits well with what I want to do. However, I need help to create a search that will ONLY find the product category (not...

Hi, I would like to know if there is any sample/guide I can follow to build a property leasing database. There will be different types of items in categories, e.g: COMPUTERS: 1. HP Compaq Serial No. 12345 2. HP Compaq Serial No. 6789 3. Genius ... PRINTERS: 1. 2. SCANNERS: 1. 2. 3 ETC The...

Hi, Sorry, I delayed to come back. However, after several attempts with this I cannot get the query passed to the pop up form. What am i missing? My code is as follows: Dim strForm, varWhere As String strForm = "frmSlideShow" 'cmdSlideShow_Click varWhere =...

I have a situation where a victim claims can identify a suspect's face. So basing on age range and other personal attributes distribed by the victim a query is run and matching records are displayed in a form with small image previews. I want the results of this query as displayed to pass to...

Hi, The form is NOT continuous, and yes the imgDeceased is unbound. It's a png format ment to display across diagonally. See attached short if that would be possible to do. Thanks. Joseph