Search results

I have a table with an autonumber field and a char field. I have a query that sorts that table by the a character field, and return the key field as well (the autonumber field). I also have a form with a combobox that uses that query as its source, it displays the character field, but saves the...

I created a form in access VBA that sends emails to our clients every month. The form has a textbox that shows the list of all the recipients to which the email was sent. ( a small report). I would like to be able to print that report and save it to a file as a plain .txt file. Could you guide...

Hello all, I have a little problem, hope you can help me. I have a form that selects a recordset, and make some modifications to the db. When it can not modify a record, it saves in a string the record nunmber and the reason why it can not be updated. After the form ends its process, I want to...

The title says it all. Is it posible? How? I have not been able to find a straight answer and/or example. Thank you guys for any help.

[RESOLVED]How to get the caption of a radio button with a function Hello guys, I hope you can give me a hand. I want to have a function that I can pass a frame to (a frame that contains a group of radio buttons), and return the caption of the button selected. Basically I have two problems, I...

Hello guys, I hope you can help me with this one. I creaated a Word template with fields. I populate this template from an access form, using a "print to word" button with vb code. The template gets populated ok, picking up the data from a make-table. Te problem is that I can not save that...

How to carry the db front end home I have a front end for my db. I would like to be ablo to carry it home to work on some modifications. What is the right way of doing that without creating conflicts? i can even carry the db too. What I have done so far, is I would make modifications at home...

I have several databases, and a couple of tables are linked from one db to another. The thing is from db A, I would like to also use a couple of forms of dbB. This is because in order to create a complete record in db A I need first to enter some data in db B. So i figured I would call from THIS...

My question is this. I have about 4 different databases, and for each database, i have 1 or 2 forms that i use frecuently. Can I have like a form of forms, where I can select this or that form, without having to go into each database and activate it?

can i add common control dialog to a form? I want the user of a form in access to be able to select where to save a report as a .rtf file. and I want him/her to be able to select where to save it using a common dialog (save as) box, is there such thing in VBA? the control is not in the...

can a combobox have 2 bound fields? I use a combobox (with uses a query) to select from a list. The thing is that two fields are needed to make a record unique. I need to hold columns number 1 and 2. How can I do that? any suggestions? thank you:confused:

I have a bound form that uses a query to get data from 2 tables, it had worked fine, but today I was going to enter record # 400 and it wont accept it. It lets me modify the old ones, but when I want to create a new one, the text fields dont accept new data, they keep blank. I press a key, and...

I have this report, it is suposed to sort using three different fields, but it actually sorts using only the first field, and ignores the other two. Can someone tell me why? thank you select tblPlanInfo.lngPSINumb, tblPlanInfo.chrPlanLtr, tblPlanInfo.chrPlanName...

I have this report, it is suposed to sort using three different fields, but it actually sorts using only the first field, and ignores the other two. Can someone tell me why? thank you select tblPlanInfo.lngPSINumb, tblPlanInfo.chrPlanLtr, tblPlanInfo.chrPlanName...

I created a report using several tables, I wrote the SQL in the query window, It is ordered by one field. The report is fine, but it lists all the records one after the other. I want the report to have maximum one record per page, how do I do that? Thank you guys

need help learning access I am learning access (reading) , I am so lost. I just have questions and more questions. I wonder if some of you would be willing to chat with me, to clarify some of those. I use either aol (juancriano) or msn (juan_riano@hotmail.com). Thank you guys