Search results

let say i have a text box in a report that brings in function someFunction that outputs a string, in someFunction, how do I get a fields value, of the correct relative row? would this function be able to be used in a module, or does it need to be part of the report code? How can I design...

How would I set something like this up. I have a text box named qtyText with the value [qty] how to I make this text box become bold everytime the qty value is greater than 7?

how to run a macro that alters a record value in a report. I think this is a pretty straight forward question. I have a report with a textbox with control source 'FirstName'. and an example macro in a module like this Public Function test(v As Variant) As Variant test = v + "test" End...

I have the following two queries Query1: SELECT TAGS.ID, ALARMS.* FROM TAGS RIGHT JOIN ALARMS ON TAGS.NAME1=ALARMS.NAME1; Query2: SELECT SUBGROUPS.*, Query1.* FROM SUBGROUPS LEFT JOIN Query1 ON SUBGROUPS.ID=Query1.ID; How do I combine these to make one?

I have the following problem. I have 3 tables made up of ID and NAME and other parameters. NAME is unique field in each table, whilst ID is not unique. the three tables share the same fields, but can't be combined due to the NAME field not being unique throughout. Now I have a single table...

I am trying to obtain a list of all tables in my database that will be used to populate a combobox. The way I would assume to do this (in excel) is: Dim r as recordset For each r in recordsets combobox1.additem r.name Next r but obviously it isn't the same in access, so could someone...

i have run into the problem where I want to change parameters of a report in vba but it states I need to open the report first, which is no good. at the moment I am just wanting to do the following Dim r As Report Set r = Reports("myReport") but this only works when the report is open, is...

Hi. I have created a report from a recordset that works well. Now what I want to do is only create pages if the record meets some specific criterior in a field. ie, say I have field called 'Colour', how would I create reports for only the records that have 'Black' as the value. thanks

I was wondering if there was some way of achieving this. Lets say I have 12 checkboxes named 'checkbox1' ..'checkbox12' I want to assign their value to an array say 'arr(1 to 12)' in stead of writing code for each one and assigning it to an array index, can I somehow do this: for i = 1 to 12...

Hello all. I am very new to access, wanting to get good with it as I am with excel. My problem is: I have created a report using the report wizard that gets the values from a specific table. Now if I have a second tabled with exactly the same fields how do I change the report to look at that...