Search results

why not just use the base table to track changes as well? each new record (row) will be timestamped and allow you to view previous changes.

thanks for the reply. To further clarify, I have a report that has its report source modified through code. The report sources (in this case queries) doesn't have the same fields, hence there are fields on the report that may be in one query but not the other. If the field is not in the query...

okay, maybe I should simplify the question I want to show a value on a report, only if the field exists in a table, how do I ahceive this?

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...

Okay, I did a google search and now understand conditional formating. But what if i want to change the font size? how would I do that? EDIT: okay I solved this one myself (again) with an on event in the detail section a macro was created that changed exactly what i was after

Okay, so i construct the Control Source using the iff command? but how exactly do i set that up? I have tried something like =IIf([qty]>7,qtyText.FontBold=Yes,[qty]) but it doesn't bold the value, and also how do I seperate multiple statements?

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?

Okay. i wil answer this one myself. don't know why it wasn't working yesterday :? the control source will need to be =test([FirstName])

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...

WORKED IT OUT! SELECT SUBGROUPS.*, combined.* FROM SUBGROUPS LEFT JOIN [SELECT TAGS.ID, ALARMS.* FROM TAGS RIGHT JOIN ALARMS ON TAGS.NAME1=ALARMS.NAME1]. AS combined ON SUBGROUPS.ID=combined.ID; thanks to this link SQL - subqueries and "parallel left joins"

thanks for the reply, i tried your code and it didn't seam to work, I then tried to modify it and try a lot of different things, and still couldn't make it work. SELECT SUBGROUPS.*, (SELECT TAGS.ID, ALARMS.* FROM TAGS RIGHT JOIN ALARMS ON TAGS.NAME1=ALARMS.NAME1;) AS QUERY1temp FROM SUBGROUPS...

bump. I thought this problem what be fairly straight forward to answer. basically how do I embed two sql queries together...

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?

okay, this how I managed to solve my problem... thought it would be useful to let people know. Firstly I did a join on the matching pairs of tables, with table1.name = table2.name then I unioned these 3 tables together. from this query I created the relationship. edit: I spoke too soon. the...

Thanks for the replies and mentioning about fields named "NAME", didn't knwo that. I will explain my situation abit more, and the reason the database is designed that way. Firstly, I don't create any of the tables myself. So the 3 different tables come from 3 different locations, I wish I...

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...

Thanks mate! just what i wanted

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...

thanks for the reply, might have to do that. I also thought of using visible = false after opening a report. pity you have to have the report opened

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...