Search results

Hi AccessBlaster, I searched the keyword you just mentioned but I could not find a solution for my problem. Can you please make it more clear?

Hi all, Happy new year. I am new in access. I have a form that uses VBA codes to write all the info from the controls in the form into different relational tables. I was stopped at the point that I wanted to have repeating controls. Collect multiple instances of the same type of data, such as...

How to make a function working with different inputs at the same time? Hello, I am new in Access and need help. I want to write a VBA code to do the same job more than once with different inputs. To be more clear the following is a VBA code to update/record values in two different tables. The...

Hello, I am new in Access and need help. I want to write a VBA code to do the same job more than once with different inputs. To be more clear the following is a VBA code to update/record values in two different tables. The values are serial numbers in different ranges (serial numbers to be added...

Hi all, I was able to figure it out. The error was given because I had closed db before I started the query "qry_remove_invID".

Hi, Thanks for your helps. I modified my tables and relationships. As you can see in the attached image the inv_ID in tbl_allPins is a FK. Removing the inv_ID helps me to know that I can sell it to another vendor in a new invoice. I do not think adding another field for available cards is right...

I have been looking for a solution in this site but there was no success. :banghead: I have a pretty normalized Access Database but you can take a look at it (open the attachment) and if it was not normalized properly let me know corrections. The table that I am trying to add new records is...

Hi Jonathanchye, I had a problem and someone gave me a set of VBA codes to fix it and you completed it. Now I have difficulty when matching variables in my database. Can you please help me on that? If yes, please look at the questions and answer in this thread. Thanks in advance.

Hi all, Please help! I am new in DB access! I have a DB with several relational tables. I want to add new records to a table (tbl_returns). To add new records (serial number of returned cards) I am using a regular form. There is a serial number for each returned card. The problem came up when I...

Hi Pat Hartman, Thanks for your respond. It took me a long time to find variables in your code and switch them with matched variables in my form. Anyway, there are some parts missing that I have no idea how to complete them. If you look at the form "frm_returns " in my database I am sure it is...

Hell Star Grabber, Thanks for all helps in last post. I've posted a new question and please help me if you have time.

Hi all, Please help! I have a DB with several relational tables. I want to add new records to a table (tbl_returns). To add new records (serial number of returned cards) I am using a regular form. There is a serial number for each returned card. The problem came up when I wanted to add more than...

It works perfectly right now! :) Thank you very much StarGrabber! I learned many things about the VBA and its concepts, still need to learn more, so I keep working on the other parts of this project. Will come back with new questions!:cool:

I am sorry but it does not work. There should be a misunderstanding error. I deleted the procedure 'cmdAssignPins_Click', renamed the button 'cmdAssignPins' to 'cmdSave' in my form and created a new procedure: Private Sub cmdSave_Click() DoCmd.RunCommand acCmdSaveRecord End Sub After you...

Hi starGrabber, I am still learning from all your writings. I modified the codes as you said, I deleted the procedure 'cmdAssignPins_Click', renamed the button 'cmdAssignPins' to 'cmdSave' in my form and created a new procedure: Private Sub cmdSave_Click() DoCmd.RunCommand acCmdSaveRecord...

Hi StarGrabber, Here are my questions. I will appreciate all your helps. In line 10 procedure cmdAssignPins_Click() checks if there is no value to process, exits the procedure. Since the button is not active at this point why do we need this check? In line 39 what is the purpose of...

Hi starGrabber, Thank you for all you did on my project. I could not guess how hard it is to add an ID into a table. Is there anyway to execute qupdPinsWithInvID by pressing the same key where saving the invoice details? (using a kind of macro) I have some more questions about your code...

This is suppose to hold all data's about the sold calling cards, invoices, retail stores who sell my cards and customer comments when they call for any reason, bad quality, bad connection and etc. Another table including all call duration report (CDR) will be added to this database in future...

Hello John. Here is a copy of my DB attached. It is not completed yet but you can see the relationships and get the concept. Thanks for all your helps. The method to add an ID from a parent table (PK) to a child table (FK) simultaneously using a single form is very helpful to get this project...

I am a new member with only one post. Can new members upload a DB?