Search results

Is it not possible to use a macro and the set value field? I need to run the report and save it several times? How do you use the set value?

I am trying to run a report that is based on an underlying query. The query usually prompts the user for an input but I want to take this out and apply a value before it is run. So I want to first launch the query with the value LG and then run the report based on this value. There are several...

Running Report Thanks for your help guts. I have now managed to resolve the problems. I copied the reports and modified both the underlying queries and the references to fields within the query and table that the report related to. It now works fine. Thanks

Report Running The report [repTOR4]! is the original report. Behid the report is a query which prompted the user for some sort of input. The typical inputs are SG, LG, and WG. The user must choose out of these three. The report itself had to be run three times once for each of the inputs. The...

Hi Guys, I have a report that at the moment requires user input, that is it prompts the user for an input before executing. A typical input would be LG, SG or WG. Upon inputting this value the report executes and produces a report. However I have a problem. I want to try and automate all of...

Is it possible to run a macro that you have hidden (using the properties of the object) in code? That is if I was to hide the macro then in the code write docmd.runmacro "macroname that has been hidden" would this execute or return an error? Thanks

Hi guys, I have created a module as shown below, which was initially a macro. The syntax is as follows; I cannot seem to get the text box on the form frmbps to display the text. It returns errors regarding accessing forms, text box enabled, etc. Any ideas? Option Compare Database Option...

Thanks that worked great

Is it possible to run a module from within a macro? I have created several module and wanted to run them from within a single module. I have tried using 'OpenModule' but this simply shows the syntax? Is there anyway I can execute a module from within a macro? If there is does anyone know the...

Is this syntax valid? Function testmacroconverttocode() On Error GoTo testmacroconverttocode_Err Dim mydb As Database Dim var As Long Set mydb = DBEngine.Workspaces(0).Databases(0) Dim WeekNumber As Recordset DoCmd.OpenQuery "q_Calculate week number"...

Can I reference it from a table though? The table it gets the data from is tblWeek. From here the week number is picked up from a column named 'week'. If I was to call the recordset by something else should i be able to reference the table?

I am trying to access a field in a table and append the contents of that field to the end of a file name. The name of the table is WeekNo, and the field I am trying to access is Week. A query creates the table. All I am trying to do is append the contents to a file named c:\avL "& Week & ".rtf...

Renaming files Thats great thanks. That is the first time i have used such a function. If I was to reference a table typically named tblweek, would I replace the "Form!" in you example with table!, or is there different syntax. Thanks again :)

I have written several macros that firstly initiate a query, and then output the report as an *rtf to a location locally on my pc. The way in which the file(s) are named are as follows c:\reports\avXXPP.rtf, where XX is the week number and PP is the publication. Does anyone know of a macro I...

Thanks for the advice Fornation. The thing is I already have a job, I work as a trainee DBA for the UKs largest publishing company. They have many databases already, and they have offered me some project work, working on the existing databases, but I would like to do something away from this! I...

Useful services How about asection for students discussing projects and modules that they are currently undertaking. Many students like myself complete similar modules through the duration of your course. Sharing ideas on topics, etc, would be very useful. Although much of the information...

Hi Guys, I know this is not your typical type of question, but ill ask it anyway. For my final year project in university I have to come up with a Project that will last for anything up t six months. I need to design, develop,maintain and enhance a database package or solution. I am really...

Does anyone know how to create a message box function based on the value of a column within a table. I want to create one within the criteria field of a SELECT query that checks whether the count is greater than one, and if it is displays a message bx informing the userof the actual figure, and...

Does anyone know how to re-install the text driver import, after Access has been removed and then re-installed? I have re-installed the full version, updated the service pack to SP2-b, and have installed the valupack97? Any ideas? Thanks

Importing data into a table Apologies for the duplicate entries I wasnt sure which discussion group to drop the request in. The file I am attempting to import is extremly large, and the records within the table are of a byte size similar to that you disucussed in an earlier thread. I have...