Search results

Hello all again, So... I think I know the answer but I am not sure how to execute it. I have two tables 1. Package Information 2. Package Uses Table 1 contains information about packages, from what the package contains, contacts, priority etc etc. Table 2 contains information about when the...

Nono, I didnt want to use the AutoExec macro because this would run when I open the db, which I dont want... I created a module and called in AutoRun.. I just named the module that, I dont actually want it to run on startup. I then entered into the arguments section on the tasker...

well... I guess that is a good question because I don't know... Within VBA I right click, created a module (not a class module) and its called "AutoRun"... I didnt want to call it AutoExec to execute on open, it was just a placeholder name to run automatically lol. also, when I go into Access...

Hello All, so I have scheduled a macro using the following settings within task scheduler: Actions: Start a program Program/Script: "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" Arguements: "\\firo\Testing\dbname.accdb" /x PropReport and the macro I am trying to...

Because this was a subform it had to be dealt with like so: Public Sub Fun_Test() Forms!Main!ClusterSubform.Form!Sequence.ColumnWidth = 250 End Sub

hello, I want to put some form functions into a module but it says that it cannot find the form... here is what I currently have in the module: Public Sub Fun_Test() Forms!Form_Output!Sequence.ColumnWidth = 250 End Sub my form name is "Form_Output" but it still cant find it... does anyone...

they will do.. so that one table is completely blank (for entering data) and the other table is the main table for storing all the data. I could create a form with a text box for each entry but I might be required to make 30+ rows of boxes... its not an ideal way of doing it. Im sure there...

well... i have a form where you select a category and it will view all incidents under that category... if you want to add an incident, id like to be able to fill in the form without having to enter the category (as you already selected the category from the main form) i guess it doesnt have to...

hello all! I have a subform that is essentially a blank table which users can create rows depending on how many they require and fill the table in. I then want to be able to append a main table with the records that have just been created in the subform's table... but here is where an issue...

I have two questions to this method: 1. is it possible to filter the "subform query", if so... how would i go about doing it? 2. I would like to remove a few things from the sub query such as: scroll bar the bottom bar that tells me what "record im on", whether a filter is active and a...

Hello again :) I have a database which is supposed to record issues that have been identified in process documents filed by specific teams. part of the database is dedicated to collecting names and contact points for the particular teams and this section of the database is fine. with...

BINGO! I didnt realise you could do conditional formatting on access... Is it possible to copy and paste the conditional formatting... because I've got to repeat this for several boxes :P Thanks so much for that!

does this make more sense of what the report is trying to accomplish?

I have attached a workbook trying to explain what i want to do... I can make the reports state the number, i just cant get the report to show a color depending on that number (rank in the excel spreadsheet)

I have a report which has a parameter. The parameter returns between 1 and 5 results and gives out a report for each result (as expected) each result will contain a number between 1 and 3 which I was to display as a colored block. (1 = red, 2 = yellow, 3 = green). normally with a report...

ahhh sorry I thought you were asking if my free form text box was normalized. yea i didnt design the database nor do I have the ability to change the tables within, only apply rules to the data. I realise it would be good to make it restrictive but unfortunately I cant =( is there anyway to...

yes its the latter. Again, the problem with a number field with a prefix is that the RQ# incidents will not be allowed to be entered there. what do you mean "if your data is normalised" also, good question... how do i ensure that two users dont use the same incident number.... difficult to...

When we are managing incidents, users have decided on their own method of recording the incident... here are some examples INC002546 INCIDENT002546 2546 INC# 2546 Inc# 2546 inc# 2546 Inc # 2546 and more... you get the point anyway :banghead: The correct way is the following: Inc# 2546 ^...

Hello again :o I have been using access daily now for over a year and I have a confession. I have never used reports... I've just never needed it! Ok but here is the time in which I think I do need to use reports. I have a list of companies in the database and I want to display the...

oh, there is currently no macro but i can write one... i just wondered if i could do it in a better way then how i described it above... Its a rather long way around but if thats the only method, i shall try. Is it possible to run a macro from a work book from inside access? How would I go...