Microsoft Access / VBA Forum

Hello, I have a popup form I am trying to "make clever" so it could behave accordingly to which report is opened in the background. Do you know how this popup form can retrieve the name of the (open) report in the background ? Have you some code doing this?

Hi Guys I have recently been learning SQL from a book whose examples used the Oracle engine. I have now made an Access database containing information for English Football fixtures. I am using ASP pages and ADO to access and query this database for information. One piece of information I want to retrieve is a list of all the football...

Hi all, i want to combine an old db with a new one, but i'm not sure how to do this. old tables: COMPANY with a one-to-many relation to HISTORY. i want to insert the old tables into the new db and retain the relationships with the history table. I would like some suggestions on how to do this. thanks in advance!

Is there any way to detect within A97 when Windows is trying to shut down, so I can close down the application gracefully? We currently have a trap in the main menu asking the user to confirm if they want to shut the application. If the user is not at his desk and power fails and the UPS instructs Windows to close, then Windows will not...

From what I understand, an Inner Join narrow the rows selected to the table with the least results... and an Outer Join does the opposite... SELECT qryTxToQ1.Q1Total, qryTxToQ2.Q2Total, qryTxToQ3.Q3Total, qryTxToQ4.Q4Total FROM qryTxToQ4 OUTER JOIN (qryTxToQ3 OUTER JOIN (qryTxToQ1 OUTER JOIN qryTxToQ2 ON qryTxToQ1.TxAcct_ID =...

I got a database which containce a record with 28 fields, the first 3 fields contain systemname date and hardwaredevice the other fields have performance data. When I open the table I can see the which hour uses the most resources. I tried to run a query which show me the highest usage within the record. day: Max( ) it tells me I need an...

Hi NG I have made a report in access, and i have used the OutPutTo to transfer it to word (rft format). It is a letter with addressheader, date, sign etc. The user should always add something in the letter, so I want the cursor default to be placed on that specific spot everytime - but I have no idea how I do that. Thanks in advance Anne

I have a module called GetDocIndex which calculates a sequential number in a control called CommDocNbrtxt. On the BeforeUpdate property of the form I have the following code Private Sub Form_BeforeUpdate(Cancel As Integer) > > If Len(Nz(Me.CommDocNbrtxt, "")) = 0 Then > Me.CommDocNbrtxt.Value = GetDocIndex > End If The control...

I'd like a query that searches through a table (Table1) and looks for a comma in just one particular field (Field1), and removes just that comma if found... Anyone help with this one? Ta Lap

Hallo! I can show Autocad drawings in a Access Form useing Autodesk Volo View Control field. But I can not print out this fields. The data of the drawing are stord on a table with path and file name. Can someone help me? Josef Heinz

Hi Should a hidden form become visible when all other forms are closed? This is what happens, and to ensure that it is always hidden, I have to set the on got focus event handler of the form to Me.Visible = False to ensure that it is always hidden, no matter what.

Hi all, I have a web site which allows our customers to write data via forms into an access table stored on our ISP's remote server. My question is how do I efficiently retrieve the data? ISP tells me I am only allowed access to the web site via Frontpage. Even if I could set up a linked table from my desktop PC I understand that...

Dear All, I found this code snippet on this list (taken from a nice webpage of a courteous fellow), which I used to filter a form on a combo box. I wanted to repeat the same code to have an additional combo control doing a different filtering on the same form, and simply copied the code below and changed the appropriate combo names....

Software: Office XP Systeem: Win 2000 I'v been trying to merge an access database OLE field (containing RTF text) into a word doc. The mail merge works OK, all database fields are added except the OLE field which is displayed as "Long binnary value or text" in the word doc after the merge.

An Access database connected to a PostgreSQL back-end. Sometimes, when I close a form, i get a message saying that the action will reset the current code in break mode. The front-end literally has has no code! I've tried various repair techniques, but the problem always returns. When this happens, if I say yes to reset the code, the...

Office 2000 From Access I've been starting an instance of word and doing a mail merge. Everything hunky-dory until I applied SP1 yesterday. Now this: dim wrd as Object set wrd = CreateObject("Word.Application")

Office 2000 From Access I've been starting an instance of word and doing a mail merge. Everything hunky-dory until I applied SP1 yesterday. Now this: dim wrd as Object set wrd = CreateObject("Word.Application")

I'm using OutputTo to send data into Excel. It has been working nicely. Now, I need to add more worksheets using OutputTo. Whenever I use it, it replaces the existing worksheet. Is there any way to get OutputTo to create more than one worksheet?

Hello, I wish to change a command button's vba script according to different values (so it is dynamic) For example : if A=4 then the script attached to the command button is "here the first vba script"

I remember that I used to set up utility batch files, and create Windows shortcuts to them that would ask the user for parameters to supply to the batch files. From what I can tell, this functionality simply doesn't exist anymore in Windows 2000 or above. I did find a work-around to this that I thought y'all might want to know about. ...

I have a button on a form that opens a report. I need to set the caption of several labels on the report equal to the value of a columns in comboboxes on the form something like: LabelOnReport.Caption = ComboboxOnForm(2) Where the boundcolumn of the combobox is 1. I keep getting an error message no matter what I try. How is this done?

My formatting got hosed the first time I posted this so here goes again: I've been working on an Access 2000 database for a couple of weeks now. I took a course in access about a year ago, a crash course, and I learned a ton, but I didn't touch Access for the year since then so I forgot everything I learned : ( So this little project I...

I know this should be easy (I think), but I can not figure out how to do it. Basically, I have 4 tables (2 tables with 2 subordinate tables) that have an INQ_ID key that was created by using "Auto-increment". (What I mean by 4 tables is that I have 2 "Main" tables with a subordinate table tied to each of them.) Now, I have to merge...

I've been working on an Access 2000 database for a couple of weeks now. I took a course in access about a year ago, a crash course, and I learned a ton, but I didn't touch Access for the year since then so I forgot everything I learned : ( So this little project I envisioned has turned out to be much harder than I thought. But I think I'm...

I have many reports in my database. All but one opens at 100%. The one opens at "Fit". How do I make that one open at 100%? Thanks for all help! Steve