Search results

this is fine.

but what if they open the form and then decide that there is nothing to enter and wish to go back?

can you please elaborate on a solution?

Sorry, my haste caused waste an i did not properly explain. When you open the select client form and select to "Add a new client" from the button in the bottom right it takes you to the client form. if you close the client form, the 2 problems occur. 1. I need to have the autonumber field on...

Please I really need help with this one!

Desperate - error Popup on close Hello, I have a form that has in the original db many popup forms linked to (not the best but i had no choice) but there are 2 problems. I need to have the autonumber field on the form to feed the popups so when the form closes it says this: ENTER PARAMETER...

thanks a lot, i was wondering if that would be the best way to do it rather than add another field. + i wasn't sure if it was that easy. Thanks Again!

year field did you input those by hand or run a query or what?

You're a bloody saint I have had a rough week (family death....) and this will really help as I have some other forms which use the same principals. Thanks a lot

I need to create a report off of the date the client started with the organization by month and year. (See pic) the date can be found in client under Date_Entered. Can someone please help with the setup? I tried and failed horribly. ~Thanks!

I have this code for a button, what to I need to add to make it open the form to a new record? Private Sub cmd_Open_Add_Client_Form_Click() On Error GoTo Err_cmd_Open_Add_Client_Form_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmClient"...

Full All in one zip now:

I AM IN A HURRY!!! FRIDAY IS MY LAST DAY!!!!! I am trying to get a chart to work on a form, I want the 'Results' to be the data shown (lines), over the date range (bottom), with value range (left) I can't get it to do this though... can someone please help.... THANK YOU! :o

I am opening a report froma form using the following code: Private Sub cmdFedRPT_Click() Dim dd As Integer Dim MyDatabase As Database Dim MyQueryDef As QueryDef Dim where As Variant If Nz(Me.cboFedDateBegin, "") = "" Then MsgBox "You must select a...

got it, thanks to everyone who helped and for all your patience. ~ :D

ok, so here is another problem... if the value entered is 0 it percieves it as null I am scraping the No flow thing and just displaying a blank. but now valid 0 entries are also blank.

again though, the problem is in setting the data to 0 if null since 0 is a valid response. thus 0 quantity is a good thing and if there was no quantity (ie no flow) that is not the same as 0 thus basing the visibility on 0 destroys valid inforamtion thanks again though

I was able to get the report to summ properly, But I am still unable to get it to display "No flow" if the value is null, since 0 is a valid entry. ~ :confused:

create a table for products that has id product price category(ie one of your 5 cbo's) quantity availability create your form based on this with your cbo's having 3 columns id product price make only product visible, and make the price the bound column whenever an item is selected/changed...

make the background white make the buttons images or appear as hyper links standardize a location (top as bar) for all command driven buttons arrange in long not wide format (like a piece of paper) remember to leave room on left for menuing system when doing layout standardize your colors...