query a query in vba  

hi guys,how would i go about in vba to query a query . this what i havewhile not rsInv.eofset rsSal = currentdb.openrecordset("select * from tblSales where field1 = '" & rsinv!field1 & "' ")Wend now tblSales... Continue Reading
Views : 3681
Monday 22nd of October 2012

Access 2000 limitations question  

Hello All, I just had a couple quick questions. My first question is access limited to a certain amount of records per table, or limited on how big (disk space wise)a database can be. The reason why I asked was I think I read access 97 had a Continue Reading
Views : 363
Monday 22nd of October 2012

Assistance with calculating the APR of a loan  

I have been unsuccessful in finding the correct formula for the APR of a loan to calculate automatically. Does anyone have the formula for calculating APR? Continue Reading
Views : 256
Monday 22nd of October 2012

query using 2 tables  

I have a query using 2 tables. However the second table is not always required and I notice that if the second table is not used then the info from just the one table is not included in the response. How can I rectify this problem? Continue Reading
Views : 473
Monday 22nd of October 2012


Hi allI'm doing a qry in design view.I have a bunch of students in grade 1 to 7. I want to find all students in the highest grade e.g 7. I could just enter 7 in the query criteria. And everything is hunky dory. But if things change and the highest... Continue Reading
Views : 298
Monday 22nd of October 2012

create table relatonships  

hi, Table:SEG_Studentfields: studentID(PK), School, Name, Password Table:Resultsfields:ID(PK), studentID, paper, score1, score2 I want to link the data in SEG_Student "studentID" to the table Results "StudentID" Continue Reading
Views : 306
Monday 22nd of October 2012

Password on a Form  

I would like to create a password on a form, but I cannot get the formto close when the wrong password is entered. I have also trieddocmd.close.Appreciate some help. Private Sub Form_Current() Dim Password, Pword Password =... Continue Reading
Views : 270
Monday 22nd of October 2012

Text box format  

Hello all -I have a text box in a report that I want to combine a label and a date field (date field is based on a table). I need to format the date field to be different than the way it is in the table though. I used the "Format" part of the property window to say... Continue Reading
Views : 301
Monday 22nd of October 2012

running sum problem..  

hi all. i have a problem which may be easily by someone but i do noe know how to approach it... i have a table called bookings with a column called 'ratetype' and a with a date column... Continue Reading
Views : 292
Monday 22nd of October 2012

ASP & MS ACCESS "Two Tables [one article and one comment]  

Hi please i have a problem withthis and i need some help, i received some great help so far thank you So much Markoc.and now i'm stucj here.I have two tables : one called reviews [rid, review]and the comments [cid, rid, review] Continue Reading
Views : 269
Monday 22nd of October 2012

Pre-Filling Forms on Web Sites  

Is it possible to write an event procedure attached to a command button in a Microsoft Access database that would use data from an established query to pre-fill data in to a form on a web site? Has anyone tried this? Continue Reading
Views : 297
Monday 22nd of October 2012

Help - Select Query & Finding Record Question  

Hello all, I have a couple questions. First I am trying to create a select query that will show the results that I have two fields , one is "Date" & the other is "Current" For the date I am using the a between statement "Between [start] and [end]. Under the "Current" I have... Continue Reading
Views : 250
Monday 22nd of October 2012

How can I display the number of records in a database  

After creating a recordset how do I display the number of records in it? Continue Reading
Views : 332
Monday 22nd of October 2012

How to fix a Reference  

I created a new database and i am getting an error. Your ILFdatabase database or project contains a missing or broken reference to the file 'SearchCtrl.ocx' Version 1.0 Can anyone help? Continue Reading
Views : 252
Monday 22nd of October 2012

Stop duplicate records  

I have an user imput form that has a unique file reference number which is typed in by the user in the first bound field. Does anyone know of a way of informing the user that the file reference number is already in use and therefore a new one must be used. At the moment the user... Continue Reading
Views : 295
Monday 22nd of October 2012

Retrieve name of current Sub or Function  

Is there a function, or an object property, which will return the name of the Sub routine or Function that is currently processing? Continue Reading
Views : 286
Monday 22nd of October 2012

Password on a command button  

Hi, i have a slight problem that i could really do with some help on.I have a form in which u can edit/add or delete details of a record. What i would like to do is when someone presse's the delete button i would like a box to pop up asking for a password to be entered... Continue Reading
Views : 296
Monday 22nd of October 2012


I have created a very simple switchboard with a few macro's to run either a form to add new records or a report based on a query. Thing is, when I try to open the switchboard, I get a module error... Since I'm really just using trial and error to create... Continue Reading
Views : 242
Monday 22nd of October 2012

Linking fields in a form!  

Ok. I have used access before to hold data but have always accessed and used it via asp. I have never actually tried to use the access forms and queries! But for a current project i am having to use it. So far its been fairly simple but im stuck on one point. I have... Continue Reading
Views : 472
Monday 22nd of October 2012

Combo Box in Table  

I have a table that someone else set up and when I open the table in datasheet view there is one of the fields that has a combo box attached to it. I need to add a value to this drop down box. When I look at the table in design view I do not see anywhere to change the drop down... Continue Reading
Views : 292
Monday 22nd of October 2012

Basic Question I think  

if i have multiple tables set up with multiple attributes and one common attribute, say email, is there a way for the user to enter once from a site or form or whatever and the email record be filled in all the tables. , that is basically the... Continue Reading
Views : 271
Monday 22nd of October 2012

building a link to table in another db from code  

i have two tables that only need to exist for the length of the user's session. i build them with ADOX in my backend database when the user starts up, and destroy them with ADOX when the user closes the application. the name of the table created varies, too, depending on the... Continue Reading
Views : 288
Monday 22nd of October 2012

Combo Box Help  

Hello, I have created a form to be used as an invoice entry screen. I have the part numbers listed as a combo box and when the part number is selected, I would like the part description and price to automatically fill in those fields on the form. Any ideas?... Continue Reading
Views : 263
Monday 22nd of October 2012

LIKE and criteria  

Is it possible to enter criteria in a LIKE function? Something like:Where customer LIKE "*[enter criteria]*" I know this doesn't work... Any way to get this working? Thx in advance. Continue Reading
Views : 247
Monday 22nd of October 2012


I generate reports of various lengths and would like them to be outlined by a solid border (both vertically and horizontally). So far I have drawn lines of fixed length but I really need a border that will grow and shrink with the length of my report. Any ideas? Continue Reading
Views : 266
Monday 22nd of October 2012

Reports and field sorting  

I have a report that has a field (4) whose data is in the form of NO.1.1.2, NO.2.1.1, NO.1.12.3, etc. It is not allowing me to have the report display with those in order, sorting this field is not offered. My report is being grouped by Fields 1, 2, and 3, no sorting. How can... Continue Reading
Views : 250
Monday 22nd of October 2012

Any way to "timestamp" record entries  

Hello, I have a database that people are wishing to have timestamps on each field and each record, is there a simple way of doing this? Thanks! Jim Continue Reading
Views : 263
Monday 22nd of October 2012

Suggestions Regarding Table  

I'm creating an employee database. This database will contain all kinds of information on the employee, e.g.; the Department & Division they are assigned to, their Position, their Pay and much more. Here's where I need your help. Our pay is composed of ranges and each range has 5... Continue Reading
Views : 249
Monday 22nd of October 2012

Re: Access Mailmerge...Desperate: msg for Colm  

Hi Colm, I'm not sure if you have picked this up, hense the resend.I am facinated by this... Continue Reading
Views : 260
Monday 22nd of October 2012

Queries, Tables and Forms  

I currently have a query and a table which I'd like to create a form for. The query has people's information in it and the table has RSVP information in it (if they need parking, etc.). I'd like to create a form so that I can type in the person's name and then it brings up their... Continue Reading
Views : 275
Monday 22nd of October 2012