Search results

Nevermind y'all. It seems that I forgot to change the pop up form setting to pop-up. I am going to have a beer. Sorry to bother!

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.

Good question :) I was just playing around with it and couldn't figure it out. I would assume that the file dropdown in Access is actually a Windows setting so I think you should look there. Can I ask why you are looking to hide this?

Thanks, I did it all backwards and just defined a textbox value as Date() and then named that textbox txtTODAY and referenced that. I will go back later and redo, but thanks for the advice!

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...

This has been a pain for months and now it works great. Thanks a bunch!

Thank Luddite Lad, Simpler than I expected. :) (how often does that happen?)

Thanks everyone, I was unaware of the TWIP thing. I actually needed to do the resizing because I wanted to switch a subform from SingleForm to DataSheet view and the DataSheet view was wider, but only to discover, now I can make the form wider on a command button click, but I can't change the...

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...

CyberLnx... SWEET. The For Each... Next loop idea is awesome. Saves TONS of time going through each control and cut / pasting code, and... it works. Thanks!

Brilliant... thank you sir.

? 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...

I would just like to thank everyone for not pointing out what an idiot I am. The answer to ? #1 was simply: me.requery here's to simplicity

Cut and paste. The tabcontrol object is weird that way. When you drag , it just puts it on top of the cntrl. If you cut your subform, then click on the tab that you want, then click paste you should be fine. You will actually see little black squares all around the tab page you want when it is...