Search results

Could you please be more specific? Thank you

Dear All, I have a form that has 2 subforms The master-child fields are set In Simple Form view I can see both subforms but in Datasheet view I can only see the first one (I mean if I expand the records only the records of the first subform appear and those of the second one are not there)...

The problem is that it does not work for me I am on the main form and trying to use this formula: Me!Subform1.Form!Subform2.Form.RecordSourcein my case it is like: Me!f_dbo_Users.Form!f_dbo_devices.Form.AllowEdits = False and I get Runtime error 2455 - invalid reference Could you please...

Many thanks!!

Dear All, I have a legacy database that contains a form that has a subform that has another subform, and there is a third one as well... (pls see screenshot) I would like to know how I can do a reference in VBA to the second and third subforms Many thanks in advance ;)

Dear All, I have a query that uses a dlookup function to fetch the previous record and it works fine DLookUp("ejfelig";"qry_report";"datum=#" & [datum]-1 & "#") I have another field: "Namefield" in the table that currently has only one value (eg. Peter) My problem is that if I add more values...

Unfortunately it turned out that I cannot make joins between queries where I used this code as the numbering always changes from query to query (it jumps one increment upwards at each run) Any advise please? Many thanks

It turned out that it does not work that well unfortunately If the keyname and keyvalue are null values or the same, the function outputs same numbers or zeros :( Any advise please? Thx!

That works perfectly!!! Many thanks!!!

This works perfectly! Thank you very much!!! :)

Thanks! The problem is that if I apply the subquery it will add numbers to the records alphabetically and not in the order of the records eg Field1 Field2 (created with subquery) A 1 C 3 B 2 I would need A 1 C 2 B 3 instead or maybe I did something incorrectly...

The order of the records returned is always OK, I do not have to sort it

The data that I am working with is really funky and unfortunately this cannot be changed I have many queries having the same number of records but there is no field to make a join So I would need a field that I could use for creating a join I have had a workaround with creating temp tables with...

This is exactly what I have done to solve this, I was just curious if that can be done with a single query instead of creating temp tables Or maybe this can also be solved with VBA to write a function that just generates increments starting at 1 to the end of the recordset...? Thank you!

Dear All, I have a query that has one output field I would like to have a VBA function that if I apply in the second field (Field2) it just writes numbers from 1 to as many records there are in the query (I dont want to sort my data, I just want those numbers to be added) eg. Field1 Field2 Y...

Thanks, but the problem is that the article is also only about numeric fields

Dear All, I have a query that has only one field and I would like to add a new field that displays the number of the record I have managed to do this for numeric fields with the help of a subquery like this: SELECT [Copy Of qapp_ext_cikk].Cikkszam, (SELECT Count(*)FROM [copy of qapp_ext_cikk]...

The second method works fine, just a little extra work Thank you! :)

That would be very manual and I would like to stay in Access The reason for being unconventional is that the data that I need to work with comes in a very unconventional format and cannot be changed

Dear All, I have multiple queries that I would like to "put the fields next to each other" each query has the same number of records and only one field These fields in each query has nothing to do with each other (ie I cannot make a join from them) I tried putting them in a query next to each...