Latest Tracked Programming Questions Of Microsoft Access

Microsoft Access : query a query in vba   (Views   2424)

Posted On: Monday 22nd of October 2012 05:58:35 AM
hi ,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 is a linked table, so...Show More

Microsoft Access : Access 2000 limitations question   (Views   234)

Posted On: Monday 22nd of October 2012 05:58:31 AM
, 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 limitation on the db could be no...Show More

Microsoft Access : Assistance with calculating the APR of a loan   (Views   139)

Posted On: Monday 22nd of October 2012 05:58:26 AM
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 APRShow More

Microsoft Access : query using 2 tables   (Views   195)

Posted On: Monday 22nd of October 2012 05:58:23 AM
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 problemShow More

Microsoft Access : Max   (Views   152)

Posted On: Monday 22nd of October 2012 05:58:18 AM
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 grade is 6.... Then the...Show More

Microsoft Access : create table relatonships   (Views   159)

Posted On: Monday 22nd of October 2012 05:58:15 AM
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" So when i use sql...Show More

Microsoft Access : Password on a Form   (Views   141)

Posted On: Monday 22nd of October 2012 05:58:10 AM
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 = "Swordfish" Pword =...Show More

Microsoft Access : Text box format   (Views   156)

Posted On: Monday 22nd of October 2012 05:58:06 AM
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 (mmmm", "yyyy) but it only...Show More

Microsoft Access : running sum problem..   (Views   145)

Posted On: Monday 22nd of October 2012 05:58:02 AM
. 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 called 'starDate'... ...Show More

Microsoft Access : ASP & MS ACCESS "Two Tables [one article and one comment]   (Views   154)

Posted On: Monday 22nd of October 2012 05:57:59 AM
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]the first two pages...Show More

Microsoft Access : Pre-Filling Forms on Web Sites   (Views   157)

Posted On: Monday 22nd of October 2012 05:57:55 AM
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 thisShow More

Microsoft Access : Help - Select Query & Finding Record Question   (Views   129)

Posted On: Monday 22nd of October 2012 05:57:50 AM
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 "Applied" & below that I...Show More

Microsoft Access : How can I display the number of records in a database   (Views   155)

Posted On: Monday 22nd of October 2012 05:57:46 AM
After creating a recordset how do I display the number of records in itShow More

Microsoft Access : How to fix a Reference   (Views   139)

Posted On: Monday 22nd of October 2012 05:57:42 AM
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 helpShow More

Microsoft Access : Stop duplicate records   (Views   150)

Posted On: Monday 22nd of October 2012 05:57:38 AM
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 is completing the...Show More

Microsoft Access : Retrieve name of current Sub or Function   (Views   145)

Posted On: Monday 22nd of October 2012 05:57:34 AM
Is there a function, or an object property, which will return the name of the Sub routine or Function that is currently processingShow More

Microsoft Access : Password on a command button   (Views   151)

Posted On: Monday 22nd of October 2012 05:57:30 AM
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 before the record is...Show More

Microsoft Access : Switchboard   (Views   124)

Posted On: Monday 22nd of October 2012 05:57:26 AM
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 this entire database...Show More

Microsoft Access : Linking fields in a form!   (Views   149)

Posted On: Monday 22nd of October 2012 05:57:22 AM
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 one table that holds...Show More

Microsoft Access : Combo Box in Table   (Views   128)

Posted On: Monday 22nd of October 2012 05:57:17 AM
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 box or even how it...Show More

Microsoft Access : Basic Question I think   (Views   128)

Posted On: Monday 22nd of October 2012 05:57:14 AM
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 way it is set up. I...Show More

Microsoft Access : building a link to table in another db from code   (Views   151)

Posted On: Monday 22nd of October 2012 05:57:10 AM
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 user (userID is built...Show More

Microsoft Access : Combo Box Help   (Views   130)

Posted On: Monday 22nd of October 2012 05:57:06 AM
, 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 Show More

Microsoft Access : LIKE and criteria   (Views   122)

Posted On: Monday 22nd of October 2012 05:57:01 AM
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.Show More

Microsoft Access : Borders   (Views   144)

Posted On: Monday 22nd of October 2012 05:56:58 AM
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 Show More

Microsoft Access : Reports and field sorting   (Views   117)

Posted On: Monday 22nd of October 2012 05:56:53 AM
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 the data then...Show More

Microsoft Access : Any way to "timestamp" record entries   (Views   125)

Posted On: Monday 22nd of October 2012 05:56:50 AM
, 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 Show More

Microsoft Access : Suggestions Regarding Table   (Views   126)

Posted On: Monday 22nd of October 2012 05:56:46 AM
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 steps, example...Show More

Microsoft Access : Re: Access Mailmerge...Desperate: msg for Colm   (Views   116)

Posted On: Monday 22nd of October 2012 05:56:42 AM
Hi Colm, I'm not sure if you have picked this up, hense the resend.I am facinated by this site and the very...Show More

Microsoft Access : Queries, Tables and Forms   (Views   124)

Posted On: Monday 22nd of October 2012 05:56:38 AM
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 address (just to...Show More