Search results

I have different teams ( say TeamA , TeamB , TeamC ) , each team need separate sequential Work Order Numbers ( if work order is created by TeamA member it should see the last order number and add one to it ) tblCurrentMaxIDFmly contains the last Id number used by the team and this is updated...

I am in development stage and I have used the security wizard from MS access for most users I have given Full Access writes. During testing Something the database gives me message that that “the database is Readonly” when I am the only user at this point and some how I am self locking myself...

What my user wants to do is select certain portion of the filed and make it BOLD. I have a form for this data entry ( The filed name is ProductDescription ) but MS access wont allow me to bold partial section. My user does not have certain rule which portion of the filed they want to Bold...

I have one main form were user have an option to select a criteria from the drop down. The criteria table contains the CriteriaType as one column/filed and other 130 fields (say filed F1 through F 130 that are Yes/No check box) CriteriaType F1 F2 F3 F4 F5 F6 F7...

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the...

I have main form and that has one sub-form , this Main form governs/determines the data in the sub form. This Sub form ( DataSheet Mode) has approximately 130 columns and based on the Main form criteria only ~ 20 columns has to be filled. What I want to do is based on the main forms criteria I...

Dose any one know how to search application name or how to add other application to CreateObject . For example the code below will open WORD and prints word document “Wordtest” from MS access , I need to do similar thing BUT for a different application ( Instead of Word I want to Open...

Is it possible to compare two columns side by side to highlight/change color of difference between the two cells I need to compare and show the changes to the record from previous version and generate a report which will highlight the changes (Rather than just saying that record has changed IT...

CAN GROW: YES ---Adds extra space between report lines I have a MS Access report that I have created with a custom paper size of 5.75 inch x 1.75 inch , and the fields in this report are set to Font Size: 6 I have set height of all fields in report to 0.09" this is the height I want so that...

I need to reduce space between lines in a custom paper size report that I need to create for a label. My report custom paper size is 5.75 Inch x 1.75 Inch and the filed is Font Name: Times New Roman Font Size: 6 Can Grow: Yes Can shrink: Yes Section Detail Height: 0.0833" --- Reducing this...

Is it possible to Open EasyLabel template using MS Access command button / VBA code. Using MS Access form ,I want to create a drop down list (i.e. Combo Box : “CmbTemplateName”) of template names that are stored on network path say “T:\Projects\EasylabelTemplates”. If the user selects a...

Have anyone work on “EASYLABEL” and “MS ACCESS” Is it possible to create a “Button” on a MS Access form such that user can print Labels/barcode directly from MS Access ( When user push the button , selected qury will run to generate a table , then the EasyLabel will open and process the items...