Search results

Yes I did, and i tried it the other way by changing one place only and still same result

Nope nothing happens, it compact&repair and rename it but never moves it. Any other ideas or something else i need to try

Hi I am having a problem using the below code that I found somewhere using GOOGLE......I am not getting any error. I wanted to modify the below vba to not only compact&repair but to also move the database to another folder Option Compare Database Private Sub Form_Timer()...

Ok I think I got the form to work as needed. The only thing I would like to do is for the Header field to update automatically as the USER adds new row in the subform. I have attached an image for clarification. Example: User adds Sample No. 7 (as shown in attached picture) as soon as...

Apologize for the confusion that i caused. You got most of it right but there is no "items" the product is the item. 1. Products are tested by different test methods (Test1, Test2, etc). 2. Product tested by "Test1" (for example) cannot be tested by other test methods (NOTE: All test...

The sampleNo, is for tracking how many sample products had been tested by each test. Example Test1 lets I needed to test 30 sample products per batch size Test2 i need to test 15 sample products and so on......So with time i might have 100ds of "1" as sampleNo and "2" etccc

This what I have been able to come up with. I have attached the sample database. The thing i cant get to work still is the Sample No, I would like it to be typed in and not predefined. I also would like to be able to show the Average of the calculated weight but i get an error when I do so

This what I have so far....still cant get it to work as intended, I think having problems with the relationships and primary key. I created 4 tables 1.tblTestName (contains 11 different tests) made up of 1 column linked to frmtest. No primary Key 2.tblProductinfo (contains about 150 products)...

Mr.B....yes I actually have 4 tables. tblProductinfo - Product Table tblTestform - will be for the common items in the form such as Test Date, Tested By, Machine speed, Product Name, Validation/Trial #, etc....common items between all forms regardless of the test. tbltestSubform - This is...

Hi, I am working on adding to an existing database a "Test Form" that will be used to input product test data collected during product trials / validations replacing the current excel sheets. The reason I want to do that is I can build queries and store all data in one or by most 2 tables...

DoCmd.SendObject acSendreport, Me.reportName worked perfectly as I want. So one popup form will allow users to print and email with minimum coding. Thanks Niroth

Niroth Thanks for the info it worked thats exactly what i needed and will use the same concept for emailing too in this case i will use something along the below lines under the email button. DoCmd.SendObject acSendReport, Me.reportName, "Snapshot Format", , , , stSubject, stText Invisible...

Niroth thanks for the quick response. I have a database designed using Switchboard....So one of the buttons on the switchboard called "Preview Report". So if a user click on Preview Report Button on the Main Switchboard Menu the Preview Report Menu will open. Below is the Setup in the...

OK I googled around and did some experimenting and this what I have so far, of course I still cant get the Print and Email button to work because I am misssing something but cant figure it out First I declared a Global variable in the frmPrintEmailPopup Form, the reason I did that coz I have...

Hi, I didnt know under what section to post my question but since it involved report, form and vba I thought I post it under GENERAL, so apologize if this is not the appropriate place. This what I am trying to do. I have an Access Database designed using Switchboard to open different forms...

I also used the below in that way the user will have to fill the enabled fields Private Sub Combo27_AfterUpdate() If Me.Combo27 = "Yes" Then Me.Combo33 = "Not Applicable" Me.Combo33.Enabled = False Me.Combo36 = "Not Applicable" Me.Combo36.Enabled = False Me.Combo39 = "Not...

I figured it out, dont know if this is the best approach but it does what I have in mind Private Sub Combo27_AfterUpdate() If Me.Combo27 = "Yes" Then Me.Combo33 = "Not Applicable" Me.Combo36 = "Not Applicable" Me.Combo39 = "Not Applicable" Me.Combo42 = "Not Applicable"...

I dont have SQL, unless I am misunderstanding the question. All I have is what is in the attached database

Attached is a copy of the trial database. As you can see in the form my intention is when the user select "Yes" from "Was the Observation Safe?" I want all other fields in the form to auto populate with "Not Applicable" with the exception of "What was Safe about your observation?" in that way I...

I have a form which is used to populate a table. The form is made up of 7 fields/combo boxes style. Each combo box has its own table as "Control source". All the combo boxes have "Not Applicable" as a choice to be selected with the exception of Combo Box 1 which have only Yes and No. My...