Search results

Hello all, I have a form that has comboboxes with an "Other" option. I want to make a textbox that appears when "Other" is selected and then the user can input information. I have five combo boxes that I would like to do this on. I have put this code in the Form_Current and cbo_Change event...

I have a form for data entry that have multiple comboboxes. I am trying to get one combobox to base its "list" on an entry from a previous combobox. The first combobox is based on a QuantityType table and has four options. The next combobox is based on a ProductDesign table and will have...

Well the reason I am trying to limit the page count is because I am printing small labels and I can not figure out how to limit the width of the report I am using. So I could approach this from two directions. Here is what I have now: DoCmd.PrintOut "Label_Single", , strPrintLabel, , acHigh, 1...

Perfect! Thank you. Do you know how to just get the first page to print?

Hey all, I am trying to get a report to print straight out without opening the report in a preview. Here is what I have so far. I know I need to use doCmd.PrintOut but I can not figure out the correct syntax to get it to work. I highlighted the code in question in red. Private Sub...

Ok, so I now have the function working correctly for previously entered data. I have one more quick question to add on to this: How do I use this function abbrevShape when I am entering new data? I simply get a #Type? error. Is there something like: If Me.Dirty Then 'Save any edits...

Ok, so here is my function. Public Function abbrevShape(Shape As String) As String Select Case Shape Case "baguette" abbrevShape = "BG" Case "cushion" abbrevShape = "CC" Case "emerald" abbrevShape = "EM" Case "heart"...

That would work perfect. I am unsure of how to use functions in access though. I have been writing simple "Print Report" button controls, but where would I start to use the code you supplied?

I am attempting to create a printed label with a concatenated field. I want the field to abbreviate several shapes and colors but i will just start with the shape. =IIf([Shape]="round","RD","TH") This is what my basic statement says. I am attempting to nest other options inside of this...

Well that was a simple fix! Works perfect now. Case closed. Thank you.

Hello there, I am working on updating a database and ran into a problem with a concatenated field. I have a form "Product" that is being recreated to match what my employer would like to see. On this form I have added a header field that will give a product description. It works great with the...