ms-access-2003

SQL Virtual Table

I have my database set up as such: Each product I have has it's own table where it records the quantity sold/transaction # (so column 1 is "transactionID", column 2 is "quantity") ex) p-backScratcher (where p- is indicative of "product") There are also tables for each year which hold records of each transaction that went through. Eac...

MS Access 2003 - Form question about a control source of a text box

How can I write the control source into VBA instead of in the properties window For example if I have a textbox that divides two amounts in other text boxes, then i put =[textboxA]/[textboxB] in the control source of the properties window. how do i accomplish this in vb so that I can trigger it by events?? i know it is not the same b...

ms access 2003 - Text boxes on a form: not jumping to any text box

Ok so I add all these text boxes on an unbound form, and everytime you open a form, it sort of jumps to the first text box so you can enter some information into it. How do I get rid of that, because I do not want it to auto jump to the first text box when the form opens...i do not want it to jump to any text box when the form open at a...

MS Access 2003 - Auto assigning an Identification Number

So I have a little db that is used for new hires in terms of who, where and what they are issued. One thing that is issued is laptops with little barcode/ID numbers, and I would like the db to auto assign an available ID number when the user is saved to the db. So I have a form that users use to input the information, and it is unbound,...

MS Access 2003 - Opening a report without it printing

I used Docmd.OpenReport "Report1" from another form and it seems to just want to print the report without actually displaying it. I want to display the report, not print it ...

MS ACCESS 2003 - Question about passing information from an unbound form to a report

I use something like below to pass information from one unbound form to another (excuse the no error checking): Sub Button_Click() Dim db as DAO.database Dim rs as DAO.recordset Dim sql as string docmd.openform "NextFormIamAbouttoUse" sql = "SELECT * FROM tblMain WHERE MainID = " & Me.As_MainID & ";" ' usually debug here set db = cu...

MS Access 2003 - VBA for Parameter box that open after code is run: auto "ok"??

So there is a parameter box that open after a button click event runs an sql statement in vb for a list box to populate data. something like: me.listbox.rowsource = "SELECT tblMain.ID, TblMain.FirstName, TblMain.LastName, tblMain.MobileNumber FROM tblMain;" then i count the result for display like: me.recordcounter = me.listbox.listc...

MS Access 2003 - Having trouble with buttons not working in mde file: list box .rowsource

So I have a form that has a list box and several buttons that run sqk statements for the list box. sub on_onClick() ' error checking me.listbox.rowsource = "SELECT tblMain.First, tblMain.last FROM tblMain ORDER BY tblMain.Last;" so this kinda thing is what I use for the list box. it works fine for me in the .mdb, and after i have co...

New to programming

I have a form (Quote) with an auto-number ID, on the form at the moment are two subforms that show different items (sub 1 shows partition modules sub 2 shows partition abutments) both forms use the same parts tables to build them. Both forms are linked to the quote form using the ID. All works well until the forms is refreshed or re-lo...

MS Access ADP Disconnected Recordset Reverts

I have an Microsoft Access 2003 ADP, which uses a bound "main" form with several bound continuous-style subforms. They all utilize disconnected Recordsets via a helper class. Several users have noticed the same strange behavior: they add/edit a record in the continuous subform, they leave the record (committing the edit to the Recordse...

MS Access 2003 - Automatically show last records in list box on a form rather than first

So I have a form that has a listbox that shows like a ledger. My question is how can I make it display the last records (or have the scroll bar default to the bottom instead of the top), instead of the first few as the default. Now I don't mean reversing the order from bottom to top instead of top to bottom (though that would be a cool ...

MS Access 2003 - Radio button : click one, unselects another

So what VBA can i use to make sure that is radYes is clicked, radNo is unselected? Just a measure to make sure that if one is clicked then other cannot be Thanks! ...

MS Access 2003 - Combine last record of multiple tables into one query or table??

I have a couple of tables that are transaction tables, and I would like to make a simple pivot chart for comparative balances....which happen to be the last record of each of these tables in a field called "balance". so i know how to populate this on a form using a SQL statement, rs.movelast, but i do not know how to get to the pivot ch...

MS Access 2003 - Simple question about chart within a subform, not populating on a form unless clicked

SO I have a form that has a little subform window, the subform is just a chart on it. One question I have is why the chart will not show up in the subform window unless I click the sub form window area... something I did not do?? thanks ...

MS Access 2003 - Is there a way to programmatically define the data for a chart?

So I have some VBA for taking charts built with the Form's Chart Wizard, and automatically inserting it into PowerPoint Presentation slides. I use those chart-forms as sub forms within a larger forms that has parameters the user can select to determine what is on the chart. The idea is that the user can determine the parameter, build the...

How can I bold the font in Lotus notes when generating an email from Access 2003?

I am running Access 2003 and have created a module which sends an email to recipients from the database in Lotus Notes. It works just fine, but now I have been asked to "Bold" specific text in the email so that it is easier to read on their blackberries . Can anyone help me format the text? I'm not sure how to do this.... Here is the cod...

MS Access 2003 - Unbound Form uses INSERT statement to save to table; what about subforms?

So I have an unbound form that I use to save data to a table on button click. Is there a way I can have subforms for entry that will allow me to save data to the table within that same button click? Basically I want to add more entry options for the user, and while I know other ways to do it, I am particularly curious about doing it thi...

How can I make Access combo boxes unfurl on arrow key down?

With combo box controls, I'm used to being able tab to them, click the down arrow key to open up the options, and then use the up and down arrow keys to navigate those options. In an Access form I've designed, pressing down while a combo box is active moves to the next control. I already have tab for that, so how can I get the down arr...

MS Access 2003 - VBA for altering a table after a "SELECT * INTO tblTemp FROM tblMain" statement

Hi. I use functions like the following to make temporary tables out of crosstabs queries. Function SQL_Tester() Dim sql As String If DCount("*", "MSysObjects", "[Name]='tblTemp'") Then DoCmd.DeleteObject acTable, "tblTemp" End If sql = "SELECT * INTO tblTemp from TblMain;" Debug.Print (sql) Set db = CurrentDb db.Execute (sql...

MS Access 2003 - text box calculation on a form

Lets say I have two text boxes on a form. the first returns a count value from a SQL statement, or a domain aggregate expression, etc. the second does the same with additional parameters. Now i want to have another text box (#3) that divides one by the other for a very simple percentage. like this for a controlsource: =[textbox2]/[text...