Search results

Hi all, I have a problem with reports I make with the report wizard in access. I use the wizard to get a basic report which i modify (some easy things like rearranging fields, layout, colors etc). After I check the result of my report and close it I'm often not able anymore to reopen the...

hi try it without the .value Me!Combo71.Column(1).Value becomes Me!Combo71.Column(1) Works for me without the value

Not sure but you could try something like this just before form2 closes Forms![YourformName]!Fieldname = returnValue returnvalue = the value from form2 you want to pass back to form 1. hope it helps

Hi, it could be that your report is larger then the page margins. I often have this problem too and usually its because I made my report in design view to large to fit on one page. Regards

Hi, I'm dutch too, I'll try to give you a hand. First of all your code seems very complex for what you want to do. You can create the report/form in access, and use unbound fields. You could then write code to supply the correct label to these fields depending on the value of subtotal these...

what error do you get and which part aint working? I tried your excel part and code works fine for me

if you just want to rename the sheet, prompt the user for a sheetname then add this Set ws = Worksheets(1) 'first worksheet ws.Name = userinput

Below is the code of a program I use. The user selects the range of fields that needs to be imported. And some more fields to specify which columns need to be imported. The program imports the selection into an access table called dist_keys. I'm using ADO for this. Dim startRow As Integer Dim...

Hi, make a on change event for your combobox. And add the code there to refresh your form. In the code below I refresh a form field when i change the value in the combobox called cboCcSelect. Each time the user selects another item in the combobox it executes the on change event to refresh the...

I'm in the MMORPG community for some years now. Played wow but didn't like it really. The best one for me is still Dark Age of Camelot which I been playing for years now. Excellent PvP combat, PvE ain't that great but the realm combat thrill is a feeling I have never got in any other MMORPG Cheers

your formula could look something like this M(i) = (P - (K * i)) * R * N that should get you started if you read on how to use a loop statement in vba ;) Good luck

Just create all the buttons necessary and if button one is clicked (option 1) then you use the on_click event to show the related sub_option buttons and you hide all the other buttons. Me.buttonOption11.Visible = False 'hides button This could be a possible way to go.

If i would need to program this I would do the calculation for the assets depreciation in VBA. Make my child form fields unbound. Add a button on the parent part of the form that says calculate depreciation. When button clicked a VBA program runs and does the calculation and inserts the fields...

Indeed if you have field format on percent you need to use the right format. Right now you are checking if the percent is > 9700%. Think its 0,97 you need to use in the case statement

On the Form_Load procedure I create my combo boxes with the values in them. When a new record is added I call the Form_Load procedure again and that does the trick for me. Maybe not the best solution but works fine for me. Sometimes I create a Form_Reload procedure if I don't want to refresh...

I tried different things to add comment in the sql view but nothing seems to work tho. Maybe it's just not possible in access. If you find out how to do it, be sure to let us know :)

You have two tables one with TSCID and patient info like name, addy and so on and another table with foreign key TSCID and follow up info for that patient? You need to write a query to join these two tables based on the TSCID which the user inputs into the form. You can do this by opening...

to clsoe form i think its DoCmd.Close acForm, "Formname", ,

If you know VBA it would not be to difficult to pull this off. Is there a field indicating you need to update a record? If not you need to scan every record (and compare with access) to see if you need to update it or not, which may be time consuming. If your excel file indicates which...

Not sure, but might be because ur setting twice rsItem