Search results

Yes, but the fprjconsult is refered in [forms]!f[fprjconsult].[text4], and this doens't work. If I go through the "loaded forms" path, nothing appears under fprjconsult

Hi, I did a query which parameter is written in a text box - tprj. This text box is in a form, which is in a navigation control, which is within another navigation control. How can I refer, in the query, to this text box? The navigation forms are nmain which contains nprojects. nmainsub and...

Hi, Worked perfectly, and is much more simple. Thanks a lot

Hi guys, I'm having an anoying problem and I'm asking if anyone knows how to solve it. I this a simple code: Me.dID.value = "SELECT [tdonors].[id] FROM tdonors where [tdonors].dname = '" & Me.DName.Value & "'" Where the text box dID will be updated with the ID value from a table named...

Hi guys, I'm having an anoying problem and I'm asking if anyone knows how to solve it. I this a simple code: Me.dID.value = "SELECT [tdonors].[id] FROM tdonors where [tdonors].dname = '" & Me.DName.Value & "'" Where the text box dID will be updated with the ID value from a table named...

I tested and didn't work... it gives 0, where should give 2 or 3... I will go to a previous version of my db and see if it works there... would be any problem in the registry? or in a bug in the Access? I had another problem this morning with a recordset that was not opening, I went a copied...

Can anyone tell me what's wrong with this code? ' It worked fine before, but for some unknown reason is not counting records anymore. This is to see if is there any record departing on the same date that is the text box ETD_Txt, and if so, will open a second form Everything is stored in the...

Thanks guys, This makes sense now. I will fix it

Hi, I have the an update query that should be looking for records in one field that are not equal to a txt box (txtMovID) and replace them for the value that is in the text box - updating the new MovID in the table. My criteria is: <>[Forms]![fManifest]![MovID] - 'this is to say to look for...

Hi, I was trying to use this method to remove items from a list box, however an error message comes and say "run-time error 6014: the rowsource type property needs to be set to 'Value list' to use this method" how do i set this rowsourcetype property? I tried in the listbox properties, and...

OK, I have an main ID table where I have a pool of persons (IDs) The reg table is supposed to have record about travel. Each travel event can have up to 14 IDs. I want this to be logged for record, so we know that each ID has traveled which several dates (as one person can travel several...

Hi, I don't understand much of VBA, so I don't even know if what I'm trying to do is possible... and now this smiley is the best expression of myself. :banghead: I have one main form, with a text box that will register a record in a table "tReg" with the following fields (among other)...