Search results

Okay, searched the forum and no luck: I have a "master form" from which command buttons are placed to let the user navigate through the db. from the master I want to click a command button and open another form in pivotchart view with the settings module = false, popup = yes. and i do not...

Hello again, Just wondering if anyone knew about Access certifications. Which ones are worth while, respected, etc? Just curious. I also live and work in China so something that I could do online would be greatly appreciated :) Hope everyone is well.

Okay, I am an idiot. :( Lets say that I screwed up and used DATE as a variable in a form module. Then I realized I should not have done that, and switched it to DATE_INPUT, and now I want to reset DATE to the default access value of todays date? How do I do that? I still have this variable...

Hello again everyone, Here is the situation: ****************************************************** Form_Filter has lstbox lstCriteria1 and is multiselect (simple) when users pick their chosen criteria, I want to have a listbox on Report_1 that shows what they picked. and I want users to be...

Is it possible to have a cmd button on a form that switches the view of a subform from Single Record to Datasheet ? If so... how?

this seems simple, but alas... how do i use a toggle button to change the width of an active form? i have tried using MoveSize and Forms!myform!.width =, and both just do nothing. Thanks in advance!

Hey everyone, In my Access 2003 prof. when I go to design a report, anytime I create or modify a text box, things freeze for about 5 sec or more. I tested it on an empty database and I get the same result so I don't think it is an issue of too much data. Anyone have any suggestions or ever...

? I have a combo box that, when left empty, it tells the user that it is empty and sets the focus back to the combobox. I am using the code: If Me.cmbRECEIPT_TYPE.Value = "" Or IsNull(Me.cmbRECEIPT_TYPE.Value) = True Then MsgBox "RECEIPT TYPE can not be left blank. Please enter either...

Not sure if this is in the right forum or not, but here it goes: I have a cmb box (cmb_A) on subform SUB_A on Form_A (SUB_A is the name of the object, not the form, just for reference in this example). Cmb_A is the linked child field so that when a user changes the value for Cmb_A, another text...

So I now have a nice form, tables, etc. for Sales Items. (Thanks to all the great help on this site!) This is stuff that is say, on a menu and being sold. Now I am about to tackle the EXPENSE part of all this. I am taking a minute to think because only some of the sales items are being bought...

So it looks like this: tbl_SALESRECEIPT: SALES_ITEM_ID (PK) frm_SALESRECEIPT: record source = tbl_SALESRECEIPT This is the "master form". Not really important here, but just giving everyone and idea of what's going on. tbl_TRANSACTION: TRANSACTION_ID (PK) SALES_RECEIPT_ID (FK) SALES_ITEM_ID...

So I have made some progress in normalizing and restructuring my DB, but now I have a question about forms and queries: tbl_ITEM_PRICE: ITEM_PRICE_ID (PK) ITEM_ID (FK) ITEM_PRICE tbl_ITEMS: ITEM_ID (PK) ITEM_DESCRIPTION tbl_ITEM_DETAILS: ITEM_DETAILS_ID (PK) ITEM_ID (FK) SALES_RECEIPT_ID (FK)...

I have been posting in the theory and database structure formum, but i thought this ? might be better received here: If I have a table for say, Sales_Items and there are different types of sales items, say food and clothing, is it okay to have fields that some items don't use? ex. TABLE...

Okay, so time for a more specific question related to my last post: The db has several tables for different type of sales items: tbl_FOOD tbl_BEV etc. These tables have fields: FOOD_ID BEV_ID etc. as the PK and then fields: FOOD_NAME BEV_NAME for a text description of the item. I also...

Hello everyone, I have often referenced this site for all sorts of problems and always find it helpful. I am probably all of your's worse nightmare, a self taught / hack developer that has somehow wormed his way into a decent job doing simple Access database work for a company that is completely...