Search results

Hello, I want to hide or show a column on a subform thats in datasheet view by pressing a button on the main form. Here is the code that I tried so far on the button but neither of the code below are not working...

Thanks Issac, it was tricky and I was not positive if it was a windows clipboard problem or destination program problem or Access issue but i have experienced before where my pc did not behave the same as someonelses that was testing on the forum here so i couldnt be sure but all you guys...

Finally got it to work - thank you everyone for your suggestions and getting me to poke around more. I made a form displayed in datasheet view and set the unit price field format on the form to GENERAL NUMBER with 3 decimal places and it pastes correctly in my Outlook emails. Didnt even work...

I tried, but its not that, its actually rounding when i paste and i have to actually go into excel formatting and tell it to be 3 decimal places which then displays correctly so the info is stored but its rounding up. for example .057 is pasted as .06

i need 3 decimal places displayed for customer purposes so if my unit price in access show .073 , i have to type the 3 when i email my customer because copy/paste only gives me .07 theres nothing when i hover over it. it seems copy/paste only gives 2 decimal places and i want to know if theres a...

Hello All, I am losing decimal places when I copy from Access, whether from a table row or a form in datasheet view and paste into an email, or anywhere including here for that matter! This is a copy and paste from 3 rows of my table, but what I see in my table is: $0.0610, $0.0800, and $0.1040...

Thankyou for helping me, i am getting it together now by using the select query, takes me a minute to process sometimes but its coming along thanks again

Thank you both, i will keep working with this until i get it right

I'm not clear on step 7 - the rest is done already What code should be on the button?

thankyou will give this a try

In other words, right now my report design more or less looks like a 8.5x11 form! what i need to do is keep my report format, but put a subreport on the report to list what i selected from my listbox. Can you help me change the code to open the report and then assign the listbox choices to the...

Is it possible for me to use the code I originally used and embed a report in datasheet type view into a form? Sorry if this is confusing.

Hi DBguy, I just read what you said and this is where i get lost, because i've had no formal training in Access, but find my way though it pretty unconventionally sometimes. Thank you, I will give this a try if i can figure out where to start!

Hi DBguy, It just clicked in my mind, I'm wrong to be calling this a report, its a form only I did this as a report, my mistake. What I need is to have a form that has a report or subform listing of multiple row invoices in the center of the form with a head and footer for printing. Can I use...

Hi, I'm attempting to make a report with multiple invoices in the body of the report and could use some guidance please! So far, what I have is a form that has a multiselection listbox. First, the listbox can be filtered to a specific set of customers invoices. After the user filters the...

Hi, yes i am using afterupdate on my combobox - DBguy has tried my code on a sample form and gotten it to work, i however can not so i will have to troubleshoot differently -thanksfor the reply- if you want to see the code its been posted in this thread

ok thank you for trying, i will have to troubleshoot a different way - my form is not allowing it for some reason

Hi DBguy - were you able to recreate the problem using the code i posted?

Dim S As String S = InputBox("Please enter name (You can enter First name, Last name, or any part of the name)", "Primary Contact") If S = "" Then Exit Sub Me.Filter = "PrimaryContact LIKE ""*" & S & "*""" Me.FilterOn = True

i tried your code, my code was slightly different so i switched to your code but get the same exact thing. see code posted. Once again. this is happening if i use my filter button for contact. so for example, i filter the form by a contact name and it returns on the filter and the recordset...