Search results

I am building a database with one main form that, when a particular button is clicked, is supposed to pop up in a new window a subform about a third of the screen size. The form keeps popping up maximized, covering everything else on the screen up, with lots of unused space. I'm sure it's...

I have a form for which edits aren't allowed once the user navigates to a new record. That's how we want it. But, there is one particular field where, once data is entered in the field and the user moves on, it can't be modified...even when the user has remained in the same record! This isn't...

Well, I want to consolidate the two tables into one (the way the database should have been designed originally)

That's exactly it.

Hello, I have two auto-numbered tables, each with one-to-many relationships with a couple of other tables. The two auto-numbered tables have identical column properties, as do the tables each are linked to. How can I set up an append query to append records from one of these tables into...

Hello, I have a database with a huge table on the back-end, and then I want to set up various front-ends that will only show particular records that a user is interested in. I notice that, when I query the big table without any join, I get all the records and also a space for entering a new...

Thanks for the information, all. I think it's starting to make sense to me. It can be so tough working on a database that someone else made!

I have come across a database that features the following code, which (I think) is designed to, after user confirmation, run an update query that updates some records as "signed-off" (i.e. validated). The code is like so: Private Sub Timestamp_Click() On Error GoTo Err_Timestamp_Click Dim...

Wow, I'll try that out. Thanks!

Is there any way to "lock down" newly created records somehow, so that only the person who created them can edit them after the fact? Obviously, this would require some kind of system where everyone logged in with some kind of userID and password...and even then, I don't know how such a...

Not anymore! Thanks a million! :D

I have an "overview" continuous form that lists summary information for some records. Alongside each record is a "detail" button, the Build Event code for which is: stDocName = "F_Detail" stLinkCriteria = "[ID]=" & Me![ID] DoCmd.OpenForm stDocName, , , stLinkCriteria Clicking the...

I am an occasional user of this forum; I just wanted to mention that I was having this very same problem, and a quick Google search brought me here to the answer. Thanks!!

Thanks Keith, How would I set up a new table, to capture the additional information I need, and be able to link it to the existing table? The existing data warehouse table is AutoNumbered and the sequence can be kind of strange. The output I need on my eventual form is five Data Warehouse...

Hello, I wasn't sure which area to post this question in...since it involves queries, tables, and forms :) There is a read-only table in my company's data warehouse that stores a lot of records. I wish to set up a form that will allow users to add or relate data (fields) to each of those...

I inherited a database from someone else which has about 9000 records. When sorted, one can see that the AutoNumbering starts at about 72K...then after a while there is a jump to about 134K...then after some more records the AutoNumber suddenly goes up to about 396K. Does anyone know the most...

Got it working! Thanks for the help, everyone.

I inherited an Access database that keeps track of problem reports. Each report has the date assigned to it when entered in the appropriate form. There are some buttons on the form that are supposed to add TODAY's date automatically. So, if a problem was generated last week and dated as such...

Thank you, Bob!!

Hello, I have prepared a form similar to this: DATE: PART NUMBER: SERIAL NUMBER: DATE and PART NUMBER should be mandatory for each record. SERIAL NUMBER is optional, BUT I would like to have a confirmation box pop up if the record is submitted without a serial number...something like "No...