Search results

Hi guys and girls, What is the correct way to refer to a combobox column in vba? I'm trying to reference a combobox column on a form as a parameter in dcount statement but it's not working. It's probably something really simple but totally stumped me. This works: CountOfID =...

Hi everyone, I'm having a bit of a brain-freeze here and hope someone can help me. This loop does not seem to be working, could you please cast your experienced eyes over it and see why? It is getting stuck at rs.FindFirst strFind line. It's likely to be a really rookie mistake as I'm kinda...

I'm sure this is really simple and I'm missing something silly. The following code works perfectly for what I want to do only if I specify the criteria in the sql statement. Dim rst As DAO.Recordset Dim rsta As DAO.Recordset Dim data1, data2 As Integer Dim db As Database...

Hope someone can help me with this :)) I have a tabbed form on a database back style of which is set to transparent and works great when I uncheck the box "Use Windows Themed Controls on Forms" option in Tools > Options. Is there any way to uncheck this option automatically by a piece of code...

Could someone help me please? I am trying to open two tables for comparing values. First table contains a number of records and I need to count how many records there are, depending on a field called QuoteID. Second table contains a field specifying the maximum number of records I can have on...

Hi guys, This is just for discussion really. What does Compact and Repair actually do? If I was to set my database to compact and repair on close, am I in danger of losing any data, formatting on forms or anything? What are the pros and cons? I would really appreciate some replies. Thank you...

Hope someone can shed some light on this. I have imported the contents of my database into a new database, as all the testing is completed and want a clean start without any dummy data in it or anything. My main form which is where most of the interaction with the database goes on appears...

Hi guys, Something that's been bothering me. I have a unbound subform which acts as a placeholder for other subforms rotating on it (by changing the SourceObject), that way all the relevant subforms appear in the right place when required. It works great except, it's this great big white box...

Could anyone help me please? I have incorporated a search form (previously posted on this forum) and it is not cooperating when there's a duplicate name on the listbox. There can be more than one, say, John Smith on the database. In order to differentiate between two John Smiths, I need to be...

Could anyone see what is wrong with the code below? I am trying to produce 10 questions randomly chosen from a set of criteria. Number of questions to grab from each criteria is different so I did these using case (this was originally written by a very helpful forumer here). Most of the time it...

Erm, I feel really silly asking this because it's probably simple to do, but my brain is refusing to work.. I searched a little bit for this, but can't find an answer (probably too simple). I have a table and would like to prompt the user to enter multiple IDs of these records, separated by a...

Oh god, I will try to explain this as clearly as I can I have a testing database, where candidates sit through MCQ test and an oral test. The questions for these are selected randomly from a bank (40 questions for multiple choice and 10 questions for oral), gets put in a new table and reports...

Hi everyone, My previous post (randomisation help for total beginner) and ByteMyzer's reply helped me so much, I feel compelled to present another problem to the community. I thought I may be able modify ByteMyzer's code to do something slightly different for this new problem but I'm obviously...

Hi everyone, I have searched the VB forums and have found several very useful pointers but still couldn't solve the problem, so here it is. I am trying to design a multiple choice test. Each question belongs to a criteria (there are 106 different criteria). Each criteria has 2 or 3 multiple...