Search results

For Quest4 Hello Quest4, I have visited the website. You have thrown me into an ocean. I am not a professional programmer. I work in a quality field and want to create a simple database to know what chamber/machine are in use/red tag etc. Could you help me to solve my problem? I would really...

Thanks! Thanks Quest4 for your guidance. I will come back to you. Jit

No reply received! Would some of you please help me. I am a novice and requesting inputs from experienced people like you. Thanks in advance!

Thanks! Hello Quest4, I am really want to thank your for your mail. I am really struggling. I clarify your questions: The two tables are have one to many relationship with referential integrity. No, the second form for machine/chamber is not a subform. I just one to open this form and enter the...

Hello Everybody, Good Afternoon! I earnestly request help from you to solve a problem on form design. I am making a database of machine/chamber in use. The database consists of two tables. In the first table, I enter all the primary data about the machine/chamber such as capacity, purchasing...

Thanks WayneRyan, it has been done! You have suggested so simple solution. Till now, I have been directed round and round. A Great relief! Jit

Would anybody answer my questions Sorebrain, you got your answer. Would you or anybody please give me a clue how to solve mine, without the use of subform. I would very much appreciate anybody's help. Jit

Thanks for your prompt reply. I have not tried with subform. I will try that. Am I able to enter data in the subform? Is there also any way out for my original idea?

I am again positng my problem, so that some of you can help me. I have two tables. Table 1 has following fields: Test (primary key), TestRequirement, TestFrequency, TestOrganization. There is a associated form, Form 1 Table 2, specific record for particular test, has following fields, Test...

Would anybody here please assist me? Thanks in advance!

Hello Neil, Good Morning and thanks for your reply. You are correct in saying that I have been confused between the form and table. That is the problem with a greenhorn. To explain it more: I have made two tables. Table 1 has a specific test requirement, say Voltage, as a primary key. In that...

Hi everybody, I want to develop a simple database to store testing records. I want to use two forms to enter data, form1 to enter individual testing requirment, and form2 to enter data for individual testing (when it has been done, who has done, any problems etc). I have attached a command...

Thanks Pat! I have solved the issue. Some references were missing. I have unchecked them. Now things are working. Shankar

Thanks Rob! Thanks Rob very much! At present, I will use two buttons one for select and one for delete. Jit

Thank you very much! Hello Rob, I can do this. Could I use one buttom and attach macro to it, which will run two queries, select and delete? Once again thank you very much for your time. Jit

Hello Rob, I have complaint database, consisting of two tables, customer information and customer complaints, with corresponding forms. The tables have one to many relationship. CustomerID is the primary key. In customer complaints form, I enter customer complaint when I receive complaint. I...

Setup Macro Hello Rob, I have made a custom dialog form, with unbound textboxes for customerID, begining and ending date. In macro, I have first put Open form-dialog box, then Open select query, and then Open delete query. I have not put anywhere Stop-macro. Where should I put this...

Macro setup Hello Rob, Thanks for your reply! I have first put Open Query-Select, and then Open Query-Delete, in action column. It is not working properly. For example, when macro runs, it asks for prompt and I enter values. When delete query starts, it again asks for prompt. I feel this is...

I would appreciate, some of you can help me in this regard I have a Customer Complaint database. I want to delete specifice record based on parameters- Customer ID, Record entry begining and Ending date. However, before deleting records, I want to see which records are deleted. To achieve...

Thanks! I have set the keep together property. Now it is working. Thank you very much! Jit