Search results

compile for mde (i'm new to all this.) i have [event procedures] for a few cbo boxs on forms for which i wrote a few lines (of code?) in the vba window. 1. how do i COMPILE code then ?? 2. will compiling the code fix the db so i can mde file again ? any help please ? thanks. Piet.

no modules i don't have any modules in my db, just a few tbls, qrys, frms, reps.

please help. access error: access cannot make mde file. why not ? (i think because i messed up with the security settings in my db) never got the security issues to work anyway. how do i fix my db to make mde file again ? any help will be appreciated. thanks, piet.

simple yet complicated calculation problem... Thanks everyone for replies. The Doc Man, thanks for advice you posted in post#19. My friend, who manages a small Pest Control bussiness, and I are now back at the point where you suggested: "do it on paper first and then work towards the db". As...

such a small db, yet so complicated thanks everyone for all your replies. i am desperately trying very hard to understand what you all mean. i never realized that such a simple and small db would be so complicated. the db attached in my 1st post is my 1st PROPER db (or so i thought); just...

calculation problem continues (or not) YES, I AM VERY MUCH MORE CONFUSED THAN EVER !!Maybe I didn't mention that I have VERY LITTLE! know-how of a2k (and don't have money to attend a course in Access). Thanks for all the replies and Thanks to KenHigg for the offer to help. I guess I'll have...

Sorry for not explaining better... Yes, thank you; BUT! it now only 'diplays' (and not calculate?) this: - STOCK field display(gets) value from PRODUCTS table! example 5000; (for record1). - In the ISSUE field the user enter value example 1000. - AVAILABLE STOCK field is result of...

please help, (using a2k) I have a small db to manage a Pest Control Store room. In the attached db you will find the applicable tables, queries, and a form. In the PRODUCTS table I have field (value) STOCK(current). See Form JOBCARD ! : When I ISSUE and amount of Pest Control Poison...

please help (using a2k) I have a Main Report with 2 sub-reports. Sub-Report 1 displayes some info from a table. Sub-Report 2 (based on a Query) displays a Date, Description and a Currency VALUE. In sub-Report 2's footer section I have unbound textbox to calculate the TOTAL(sum) of the...

please help (again) don't know if this belongs in forms or general forum. sorry. on mainfrm i have cmdbutton to (hyperlink) open a msword template (*.dot) file. on click of cmdbutton, a2k db MINIMIZEs to taskbar and opens msword tmplt. this is ok. but when user closes msword doc, a2k db does...

please help, i have mainfrm with cmdbutton. on click cmdbutton: opens pop-up (modal) frm. in the popup frm is cmdbutton to printpreview report. (rep based on query) problem: when report opens, the popup frm stays on top of report (has focus ?) this i don't want. so in vba i changed visible...

hi, please help. using win2k and a2k. (new to access) i have played around with the "user level security WIZARD" but find it difficult! to set up a secure db. i know how to protect the vbacode with a pwd. i also know how to make mde file (but mde does not! prevent user from...

Good Morning, In a previous thread i asked this: In the query's underlying table is a field for "Customer Name". The query generates a Report which calculates the "Total Cost" for a specified customer. In the query I have set the criteria for the 'customer name' field to [Type the Customer's...

good morning, please help. (new to a2k) i have a Products Table with fields ProductName and Price. another Table named ClientAccount have fields Product and Quantity etc. i have Mainform to capture other info and then a Subform "client account". so in the subform the user selects a...

Got it! Thank you very much.

Please help, (again) My db will be used on several workstations running from C:\mydb The wrkstations all have only default win2k and off2k fonts. If my db/forms uses "my own font" (not installed on other pc's), will my font display in the forms once the db is copied to other pc's, or will...

Please Help, I have Mainfrm with 3 subfrms. On Open of Mainfrm, the subfrms must have Hidden property. I Have 3 CmdButtons on Mainfrm. - Click button1 must Un-hide subfrm1. - Click button2 must Hide subfrm1 and then Un-hide subfrm2. - Etc. Anyone ? Thank you. Piet.

please help. my db has many! forms. 1. on each form's header, i want to use a combo box/droplist as a "menu" with "links" for the user to access any other form in the db. something like a "quick menu". i created a table (1 field) with Hyperlinks to all the Forms, but then in the combobox's...

Thank you sir, exactly what i wanted. can i also do the following: ? the parameter prompts for: "Type the START date (dd/mm/yyyy)" and same for END date. ok, so if the user types 04/06/2004 in the parameter, it apears in that "format" on the report header. but if the user types in the parameter...

Please help. I have a Query with a Date field and Criteria: Between[Type the Start Date] And [Type the End Date]. This query generates a Report. How do I ? >> In the Report's Header I want to display the Dates that the user typed in the query's parameter, example: Report Header will show...