Search results

Hi, I have a problem with custom menubar that is used in my Access 2003 database. I have upgraded to Access 2007 and this menu appered in Add-in ribbon. Somehow i deleted that menu in add-in but now when i open database in access 2007 i get error: MS Access can not find macro or procedure Menu...

Hi everyone. I have excel file with structure: a bb ccc dd e What I want to achieve is to have a macro that will group all this rows. I am currently using this code: Sub Group() Dim i, j As Integer i = 8 Cells(i, 1).Select While Cells(i, 1).Text <> "" For j = 1 To...

Hi, You could create a form. Then use insert ActiveX control called Microsoft communication control. It's kind of a tricky to set it up for the first time. I wrote a short tutorial how to do it (search form keyword = MSCOMM). When this is set I think that you can capture it inside a variable...

Hi, anyone have some experiences with seting and printing reports to Star SP200 printer? I can't see installed printer i can only get activex control in access (which means that driver is installed).

Me.Filter = False

Yes I dont know any other way how to disable the button. I did the same thing with ESC button and it works fine.

On keypress event ----------------------------- If keycode = vbkeyreturn Then Else End If ----------------------------- If vbkeyreturn doesnt work you have to find key ascii number, Rural guy told you where you can find it. If it is not there then capture it with error traping in VBA (put a...

1) If you created form than you created query too, i sure hope soo. See record source in form options. if the field is empty then you need to create one. You can do it directly from form or go to main access form on left site you have menu (Tables, Queries, Forms,...) In Queris you can create...

You could put SQL delete query on OnClick event of button. Create delete query in query designer. Test it and see if it works fine. Go to your form and on OnClick event in VBA type: Docmd.Setwarnings = false -- hide the system message Docmd.runquery "NameOfQuery" -- not sure if this is...

Make a new field in your subform and put it in subform footer (I hope that your subform is datasheet type). In control source of that field type =Sum(NameOfQueryField) or if you have multiple fields =Sum([Field1]*[Field2]) ... Dont use field names in formula, it wont work, you have to use name...

That one is even better, just think about using 0 or 1 in formula. You could get wrong result.

Try this one: Iif(IsNull([Total];1);[Total])*Iif(IsNull([Currency];1);[Currency])

Not sure, but could be reference error (some of the objects are not supported). Or Something really wrong somewhere inside your code Check references on your VBA project. Chech your code, command somewhere on VBA menu. Hope it helps.

Hi, Create query: Put desired date into field and set WHERE condition: between Date1 and Date2. Hope it helpes.

I found a solution. For anyone using .ocx files in access. Here is what you need to do when you distribute your application: On computer where you installing your app: 1. install vb runtime. You can get it on microsoft pages. 2. Copy your .ocx file to windows/system32 folder. 3. register .ocx...

Hi everyone, My db uses activex control and mscomm to communicate with external device. Db runs ok on access 2003 and 2007 version but i can't get it to run in access runtime 2007 (its on different computer). I tested external device on that computer and connection is ok. But access db giver me...

What if you insert one more field in subform and make it display increment number of a line? That way everytime the record that has focus would be selected. In this case when you're doing update query you should include loop (search this forum there is some code for it)

I found a solution: I made another subform like first one, which shows the data from subsubform. This one can now be searched from the search line on main form. Thanks for answers.

Actually any field (see the query behind). The idea is to search the subform and subform of subform at the same time.

Thanks for your reply. What i need to know is how to search the sub - subform (see the attachment). Uses some slovenian language, i think you'll understand it.