Search results for query: *

Hi, I'm having a weird problem with access. I've got a bunch of forms in which we enter informations about companies. The problem is that when we try to create a new company, informations that we enter in the fields like the comapny name and etc. aren't saved automaticaly in the tables. The...

Hi, I'm trying to put a query that would be based on the second row of a list and I don't know how to do it! The farther i can go with the expression generator is like: Forms![Partners]![lstUsers] but i would like it to be somethin like: Forms![Partners]![lstUsers].firstname (where firstname...

Hi, I've got a form in which there is a subform. I would like to know what are the commands to reach the controls of the subform from the main form. Ex: I want to be able to do DoCmd.OpenForm form_name, , , strWhere but then apply another filter to the subform inside this one but i can't reach...

Hi, I've got a form in which there a like 5 tabs, By default when I open the form it goes to the first tab but i would like to know if there is a command in vba that allow me to specify which tab should be opened (i need the code because most of the time it must open on the first tab which is...

:O nvm it works now... sry

It doesn't work! all it does is put the rest of the code in commentaries (green) :S

Hi guys, I need to input this string as a parameter for the function dcount(it's in french but the important is the syntax): str = "[Nom_service_affaire]='Taxe sur les primes d'assurance'" The problem is that there are 3 " ' " and doesn't seem to like that :P it says that i got a missing...

No, not subform, thumbnails! I don't what the right term in access in english tho! :P Just like the tabs in firefox when you want to view multiple pages in one window, you use tabs... For now i can make tabs, but i would like to make like subtabs in one tab in particular!

Hi, I'm building a form in which there are checkboxes. Everytime you check or uncheck a checkbox, it creates a new row in table with an SQL statement. It works fine, the only problem is that everytime you click you get a message saying something like: You are about to create a new row in a...

Hi, I would like to create a form in which there are some thumbnails and I can do that and it works juste fine! But, now, I would like to create another batch of (secondary) thumbnails but inside one of the primary thumbnails and I don't know how to do that! My problem is that when I try to...

Here are some details: I converted the macro to vb code and it gives me this: With CodeContextObject Forms!Produit!txtDateDebut = VersionValidation.Date_début End With Which doesn't work. I would like to know what is the correct syntax to get the field "Date_début" from the...

Hi guys, I would like to know how can define a value in a field (with the action DefineValue from the macro action list) from a value found in a query.... When i try to input a field from the query in question, I get an error saying that "the objet does not containt a automatisation object...

:(

ok thanks that was helpfull! Now, i've got another problem: I can't make the related fields update correctly. First I made a macro that executes after an update has been made on the listbox. The macro updates all the fields related one by one. Now my problem is that, if I leave the field as they...

Hi guys, Here's the problem: I have a form in which users can select a product version and see the informations concerning this specific version of the product. To select different versions, I use a query that gives me all the version number for a specific product and all the other...