Search results

Hi all, I have a database used for quotes. I have a quote form that has a subform for quote details. In that subform you choose the products and qty. On the same line, I also have a checkbox set up for "options" . This is a product that shows up seperate from the products on the quote. I...

I am not sure if it is possible to "patent" an Access Database, but it is possible to create databases and sell them without paying royalities, by buying the Developers Version of Access and registering with Microsoft. That gives you the right to create and sell the databases you create. The...

Thank you, Rich I used the code you suggested and it worked perfectly. I am new to code, and I have alot to learn, thank you for your contribution to that knowledge. Ddakcg

Is tblCountry your main table? Do you have any parent-child relationships set up between your main table and the other tables? If you did have that relationship, and you were trying to add a record to the child, without a corresponding record to the parent, you would get that error, I think...

Is your Data Entry property in the form set to Yes

Or, you could try using temp tables. Create a query that has the info you want, and create a table based on that info. Do the same for the other info, then do an append query to tye the two tables together. Just another thought. dakcg

Try changing your joins. Most of the time, the join is for fields in both tables where the joined fields are equal. But if you want some information from one and more info from the other, change the joins to match your criteria. Just a thought dakcg

No, there should be no difference. Just pick the text field you want to update, and the text field where the info you want to use lives.

Code used Here is the code I use: Private Sub Injured_AfterUpdate() If (True) Then DoCmd.OpenForm "frmInjuryPF", acNormal, "", "", , acNormal End If End Sub Thanks for any help

Just a thought, when I do a query like that in Access, I use "Group By" to eliminate duplicates. Could that work for you? DAKCG

Hi, this is what you do- go into the macro design area and look for a Action code called SetValue. On the bottom of the macro area will be two fields: Item and Expression. In Item put the field to be updated, click on the "..." button to help find the field so you don't have to type it in...

If every user has their own copy of the database, it should be possible for you to give the users slightly different versions of the form. For the users that don't need to see that field, you don't build it into the form they are given a copy of. For the ones who need the access to the...

Greetings. I am in the middle of creating a database, and I have a problem: On a form, there are checkboxes, when a box is checked, I want to open a popup form that asks for additional information. Now, I have created the popup forms and they do report back to the table. The problem is, the...

Greetings, I have a database that creates quotes. In the main quote form there is a subform attached in a parent-child relationship. The problem is with the item number. The way it works now is the user has to type in the item number (ex: 1 then 2 then 3.. and so on). Is there any way to...

Hi all, I hope that someone can help me. I have a database that is mostly run by macros. I am now attempting to convert the macros to code, so that I can add error handling. Most of the smaller macros I have been able to change simply by resaving them as a module and then pasting them into...

Hi, I need more info before I can give you an answer. I have many reports that have subforms and I have no problems. My question is: When you print out the report, and the subform info is not there, what do you see. Is there just space where the subform info should be or is there text there? DAK

Try creating a query that gets the totals you are looking for and then link that query to the query you already have with all the other info. Good Luck DAK

I must admit, that I do not understand the code you use, because I am a novice to code, but I am good at ideas, so I am glad I could help you. Maybe you could help me with some of the code problems I am having. Who knows. DAK

Hi, Shaun, and I do understand what "I'm on about". And I think I can help. I have an idea, anyway. You speak of having a query that you run, what I need to know is: What are you querying? You have a table with the information stored in it, right? If so, there is nothing that says that you...

Thanks for the reply jwindon, but could you repeat that, in english? Because, I have to admit, you lost me!! Sorry for being so dense, but I wouldn't mind an email of a sample. You have my e-mail address right? Look forward to hearing from you. DAK [This message has been edited by dakcg...