Search results

I use this code to "press" another command button that is on the same form, Private Sub Btn_B_Click() cmd_Btn_A_Click End Sub but how do I "press" a command button from another form?

Thanks highandwild, I did it with a couple of querys and got it to work. I´m sure I didn´t do it the way you thought of but you made me think how I could get it to work anyway ;)

I have this code to transfer data from a table to a existing spreadsheet and it works fine. My question is: Is there a way to do the code more flexible so I could choose if I want to change row to transfer to? For example, I would like it to transfer first to B6 to T6 and then change to B26 to...

I guess I should try this question in th "modules & VBA" section.

So, I found this code and it works good, not great ;) Is there a way to do the code a little flexible so I could change row when I would like it to? Right now all goes in one row. Dim lngColumn As Long Dim xlx As Object, xlw As Object, xls As Object, xlc As Object Dim dbs As...

The form is bound and sure I can post a screenshot but have to wait until I´m at work.

I thought about that but I´m not sure how to export from a form in access to a specific cell in excel.

Well, it was a nightmare :) and really irretating when I noticed it didn´t work the way I wanted. I don´t know how I could do it with less controls? I´ve got a form for each person with all dates where I have comboboxes to choose N (night) or D (Day) and on the report a textbox for all dates...

Thanks for your answers. It´s for a schedule on work with 10 people for three month and I want it to look like a spreadsheet and it does, it´s just missing 30 labels that doesn´t fit because the limit of 755. Thats why it´s so many controls :) It´s only the report who needs all the controls...

Hi! I think i´ve read that maximum controls in a report is 755 and I got this message when I try to add more controls: "Microsoft Office Access can´t create any more controls on this form or report" I guess there is 755 controls on my report right now but is there a way to go around this...

Never mind, got it to work :) Thanks boblarson, you made my day.

Thank you very much for your extremly quick answer :) What expression should I use, can´t get it to work.

Hi! I use this code on a command button to copy a text from textbox 1 in form A, to textbox 2 in form B and this works great. Private Sub CmdA_Click() DoCmd.OpenForm "FormA", acNormal DoCmd.GoToRecord , , acNewRec Forms!FormA.Text1.Value = Forms!FormB.Text2.Value End Suband I use this code on a...

I will try your getuser() solution and see if I could get it to work. Why is the other more difficult to maintain?

Thanks to both of you, but I suck at vba but are trying to learn and read what you linked. Thought there was a solution to this out of vba. But I found a different thing that kind of do what I want.

Hope you can understand me when english isn´t my language. I´ve done a database on my work and renamed it to .accdr in the end. What I want is a shortcut to open the form "a" for some people and for some other I would like a shortcut to open form "b". Is that possible? Hope this make sense...

To me it sound using the Command Button Wizard would do it, i guess.

Yes, the only thing thats different is the date. Yes, consecutive day. Is this possible if I make a table whith the dates (whole year?)?

Thanks for the fast reply. The data to duplicate is text and numbers. The table has a primary key which has a counter(?). The purpose is that sometimes when I fill out the record it has to be for several days (dates), one record for each day.

Hey there, I've a form with some fields. when i fill all fields i want to duplicate that record x times. How? I thougt that i can have a independent field (textbox) where i can write the number of times i wanna duplicate that record but i don't know o to do it. Someone? thanks