Search results

Thanks beetle, In the linked table manager, do I select update all tables?

Hello everyone, I am having a bit of a problem with sharing the back end of my database on my company network. I have split my database and assigned copies of the front end to 3 other nodes while keeping the back end on a public drive. This has worked fine and dandy up until I added a new node...

Hello everyone, I am having a bit of a problem with sharing the back end of my database on my company network. I have split my database and assigned copies of the front end to 3 other nodes while keeping the back end on a public drive. This has worked fine and dandy up until I added a new node...

Yeah, thats what I thought. Thank you Paul.

Thanks for such a quick response Paul, I am still a novice at this so it is hard to explain what I am doing sometimes. I will attach a screenshot of what my form looks like so maybe you will have a better understanding. In the material Information box, I would like to multiply the job...

Thank you pbaldy, that was perfect for storing the calculated value, but how do I get the assigned controls to calculate? For example, I would like to take the job size (which is autofilled from the workorder), plug in the pay rate and have the grand total for the job calculate. I can then use...

Hello everyone, I have created frmInstallerInvoicing and would like to create calculated controls and store the calculated data in my tblInstallerInvoicing. The controls I have created are 'job size' which comes from control source qryInstallerInvoicing, and 'pay rate' which comes from...

Hello everyone, I split my database, _fe and _be, and have a few questions. I have been told by a gentleman in this forum that my .accdb files should not exceed 2Gb each. I have 20 or so tables, and at the rate that we are inputting data, it is filling up quickly. I would have to guess that I...

Thanks to all for the input... To lagbolt, Yes I would like this to run before the user moves to a new record, no, there is no default value, and yes, I need the user to choose one or both to save the record or the input will not be recorded to the tables and the form crashes. To...

Hello everyone, I have two check box controls on a form, and I would like to set some sort of validation rule to make sure that one of the boxes is checked before the form is closed. I also have many other forms with text, radio, etc. controls that I would also like to set the same rule for...

Thank you both for the useful posts. I need to dig into my Access textbook and do a little research. This program never ceases to amaze me.

Hi everyone, I have a real newbie question. First, let me tell you that I am learning VBA (slowly), and my question is (please don't laugh), are modules the code for a form? If they are, how do you turn them into a form? I have created this really cool and elaborate database for my business...

Thanks for the advice CJ, I really appreciate it!

Hello everyone, I have split my database, database_fe and database_be, and was wondering if, with one or both files, do I need to compact and repair upon shutting down for the day?

Thanks Pat

Hello all, I am currently working on a project in Visual Basic Express that I am a couple of hours into already, and when I tried to open my project, for some reason I can't access form design through solution explorer, but I can still view the code. Did my computer eat this? I would rather...

Good evening all, I am trying to combine duplicate values in a query record to create one value for the duplicate values. Attached is a copy of the query design I am working with. What I would like to achieve - if column one in record one is the same as column one record two, three, four...

Thank you once again, John. That worked like a top!

O.K. guys, All of you Access whizzes have always pulled through in the past helping me to build this hot mess of a database, and thank you all so much! Now that I have the file ready to rock, I need to know what I should know about splitting it. The database is going to be used on a...

Thats it. Thank you.