Search results

I am working on some code that is designed to allow a user to switch the value of an ID number associated with a "Status" to the number 6 by simply clicking a cmd button. Button is named 'MakeStatusBillable'. This button is on a form named "MenuItemsLoads" that has a series of ID numbers...

I am looking for ways to open a form and filter for a specific PK number where the form to be opened is a subform of a main form with the subform "under" a tab strip control. I want to Open the main and subform by clicking a textbox on a third form. The third form functions like a "Navigation"...

I have a bound form that I am working to make function like a menu (you know the old style where the items "highlight" as you move a mouse over them?) So I am using this to make a textbox "change" while the mouse is over it: Private Sub View_Activity_MouseMove(Button As Integer, Shift As...

Why would I get a #Name? error produced by a bound textbox control on a form? I am using the result set of a query to drive a form set to be viewed as a datasheet. The query results have no errors of any kind. When I put a certain textbox on the form, whether I use the form wizard, or by...

I'm trying to use a textbox on a datasheet to open a specific related report, but... I'm not getting the report for the specific record. Background: I made a datasheet that shows several fields from a query that has a large number of fields. The first two columns of the datasheet show PK...

I have three comboboxes on a subform that are synchronized with the first combox on the subform (four comboboxes total). I have the three "dependent" comboboxes synched by way of individual queries that read the PK of the first combobox. The AfterUpdate event of the first combobox requeries the...

Some conceptual questions regarding db design similar to Northwind I am currently working on designing a db that requires tables similar to Northwind for Suppliers, Products, Orders, and Customers; except that in my case the tables are: Suppliers, Work Description, Orders, and Contractors...

Hi everyone, I'm having some trouble with a select query. I want it to function like a "products", or an "orders" query. So I have relationships between the "subject table" and other tables like Company and Employee and States and Status and ShipVia. I'm pretty sure I have the tables designed...

I've used the Command Button Wizard several times for making Close Form and Open Report type command buttons. Until now, all of the command buttons produced this way had one consistant theme. Now that theme has changed. How could that happen if I didn't make any changes to any options...

I have a question regarding lookup tables and how one would best set up relationships to them. For my current project, I am using a tables called 'States' to use for lookup purposes. I also happen to want to use this table with four other tables due to the fact that contact info is a...

Access is turning my db into a locked file, but I cant figure out why. The db has never been split; it is not on a network. Also, it looks like one subform is "locked" while other parts of the db are not. My guess is that there is something wrong with the tables and the queries that are...

After reading through many threads here about copying and pasting via code and trying many examples of various strategies to do this, I need to get some advice. My attempts at this are not working. I have mailing address information for "Carriers" and also for personnel of Carriers with a...

I am attempting to use several sub-forms to display the record sets returned by a group of queries. This is just for purposes of displaying entered data. Naturally, it would be really nice to make the sub-forms so that they size vertically automatically, tall or short, depending on the number...

Hey everybody, I am trying to make some simple totals queries mostly for purposes of using the 'Groupby' function. Could someone explain to me why the Totals option is disabled under Home/Records? Doesn't seem to matter what I do using query design to get it enabled.

Hi everyone: I just recently upgraded to 2016. In making forms with this version I see that all forms seem to be "docked" to a.....oh I am not too sure what to call it....a "ribbon" I guess and selected individually when open by way of a tab control. This seems to work well when working with...