Sharing Variables Between Seperate Reports
Nov 29, 2004
Hi ya,
Still working on a products catalog. I am creating this by printing a couple of separate reports, each with its own category.
At the end of a report A I store a value (number of pages) into a variable "NumPage", defined in Visual Basic. I have made this variable public and also the sub in which it is altered (report_close()) is public.
Now I should have stored the number of pages of report A in NumPage, enabling me to start report B with the right page. However in the public sub (on_open()) of report B I am not able to display the value of NumPages (just using a messagebox to check if it works).
Does anyone know whether it is possible, and if so in which way, to pass a variable created in a module of report A to report B?
Cheers,
Thomas
View Replies
ADVERTISEMENT
Jun 26, 2007
Is it possible to access the values on one form and use them on another? For example, I have heard that the code might look something like this:
Form1.Text1.Text
When I've tried this, it doesn't work. Someone mentioned something about declaring them as Public, but they're not variables, they're actual record values on another form. Any suggestions?
Thanks!
Mike
View 8 Replies
View Related
Sep 26, 2014
I have a report reporting events that occurred today, using =Date() in the query.I want to have a control/box on the report which shows today's date by default, but enables me to select a different date with the outcome that the report refreshes and shows the events on the selected date instead.
Maybe I need a form for this although I would like to do conditional formatting so a report is better.It would also be good to be able to sort by column values, as in a table on a webpage with sort controls in the column headings which work just by clicking.
View 2 Replies
View Related
Oct 20, 2006
Hi,
I was wondering if there was a query to run that would seperate a field in a column into to.
The Current Field is Prec and the entries all are numeric numbers followed by a dash and another numeric number i.e.
9700064-0
7600049-0
Another 7 digits-one digit
I would like the first 7 in a column called prec1 and the one after the dash in a column called grp
Thanks in advance
View 2 Replies
View Related
May 24, 2005
Is it possible to have 2 sepaerate sub forms, with different source objects on a single form. I thought it was, but every time I save the main overall form, the source object of the second subform changes to the source object of the first.
Can anyone shed any light on this?
View 3 Replies
View Related
Mar 3, 2008
Hey all,
For securing a database, is it possible to set a certain password for users to view just one table? like i've lots of tables in my d.b that i plan to use a workgroup file for different users to view it, but there's one that i only want certain people to access...can this be done at all??
Cheers,
Sue.
View 2 Replies
View Related
Apr 1, 2008
Hi
I have imported data from Outlook. The field I am interested in is the
'Subject' Field. This contains 3 effective segments,
1 employee name
2 description
3 job and sub job number
example of text in field is
M.Heywood Completed Job No.1708 8
N.Curry Completed Job No.1477
I wish to move the employee name into another field and also the job and sub
job number. I have tried the following Right() Function but it is not quite
working as I want
Right$([Subject],InStr([Subject],"Completed Job No.")-1)
For the records above the results are as follows
No.1708 8
No.1477
What I really want is to only get the text after the .
Any help please as this is my first time with this function
Thanks
Richard
View 1 Replies
View Related
Feb 24, 2005
Hello,
I'm making a table with a Yes/No choice many fields which represent subscriptions.
The problem is that the subscriptions available will need to be changed fairly often - will this mean the table and the form associated with it need to be redesigned?
If so, I don't know how to make fields that change depending on a different table.
If this can't be done, I'd be interested to find out how else I could go about this.
Thanks for any help you guys can offer.
View 2 Replies
View Related
Mar 9, 2005
Is it possible to create a database and link this to a form and another database? What i want to do is link a network database with a local database on a client machine?
View 3 Replies
View Related
Jun 15, 2005
I want to import a csv file and store the good data (which matches input masks, validation etc) into one table, and all the bad data which is rejected into another table.
I've read a bit about an import error table, and although I do get errors when importing the csv file, no such table is generated.
Many thanks
Cc
View 1 Replies
View Related
Jun 12, 2006
I'm working with a linked table that has a seperate field for the date, and a seperate field for the time (which show in the linked table as '11/30/1899 9:46:00 AM'). I need to calculate the time difference between 2 entries.
How can I merge the 2 fields into a combined date/time field for my calculations?
Thanks,
Sup
View 4 Replies
View Related
Aug 11, 2005
Hi. Having a bit of a problem getting a subform to requery/refresh after running a query from a seperate form. The seperate form is acting as a 'search form' and running query qSearch.
I've tried various things (requery the form, subform etc) but here is the code I'm currently using:
Private Sub RunqSearch_Click()
DoCmd.OpenForm "Papers"
Forms.Papers.RecordSource = "qSearch"
Forms.Papers!Authors.Form.RecordSource = "qSearch"
Forms.Papers!Authors.Form!AuthorName.ControlSource = "qSearch.AuthorName"
Forms.Papers!Authors.Form.Requery
Forms.Papers.Requery
DoCmd.Close acForm, Me.Name
End Sub
The main form is requerying fine, but the subform isn't. Any help would be appreciated. Thanks
View 4 Replies
View Related
Jun 8, 2006
I am learning access on my own using MS Press step by step manual and it tells me to hold down the shift key while selecting the text boxes that are next to the labels, but when I do the labels get selected also . how do I disconnect the labels from the text boxes in order to insert space between the labels and the text boxes as it intructs me to in the book. I am able to select the labels separately, but it will not allow the text to be selected separately.
View 1 Replies
View Related
Nov 17, 2004
I want to be able to find the last value entered into a table from a form that is not based on that table. How do I go about this?
What I am trying to do is produce a 'purchase order number system' that adds 1 onto the previous number, but this purchase order can be generated on many forms and for many reasons across the database. I do not want to use autonumber.
Cheers,
Recall.
View 1 Replies
View Related
Feb 8, 2005
I am trying to create a page that can display 4 different records from a database, each one in a different div container, for a news page.
I have an access database containing news records - headline, news and date. Each record also has its own auto-numbered ID.
So far I have managed to get the asp page to display all of the records in a list by using:
recordset.movenext
Loop
and I have managed to get just 1 displayed by using:
SQL = "SELECT * FROM tblNews WHERE ID=1" and changing the ID number.
But I can't seem to find a way to display each in a different div container on the same page. Can anyone help please? I think this is really obvious but I just can't see it!
Thanks.
View 2 Replies
View Related
Mar 24, 2005
I am working on a DB and would like to include the following information on a report. The information is as follows;
tblPersonnel.Name
Tony
Jennifer
James
Tom
tblPersonnel.LOA
tblPersonnel.Vacation
Tony is on a Leave of Absence (LOA) Jennifer is on Vacation which leaves James and Tom at work. Lucky them! The fields "LOA" and "Vacation" are two separate check boxes.
I would like to limit the query to display employees that are either on a "LOA" or on "Vacation" Since they are in two separate fields how do I write the expression? I know how to limit it to only employees on LOA. Or employees who are on vacation, but how do I qry those who are on vacation or LOA?
View 3 Replies
View Related
Jun 12, 2007
I am having a problem with importing text from one form to another one. I am logging into the company server and getting the database from there. But for some reason the text will not import on my machine but it will on others. Any help would be greatly appreciated.
View 1 Replies
View Related
Jul 22, 2007
Hi,
I have a an address field in my current MS Access table that has records following this sort of format eg. 21 Brown St, 21/56 Smith St
I want to separate every word in this field in to it's own field eg. field1=21
field2=Brown
field3=St
Addresses come in different formats (see examples above, with / or - etc.)
I'd like some code to complete this in VBA - please note I'm very new to programming so unfortunately everything must be explained.
Thanks
View 1 Replies
View Related
Feb 2, 2006
Hi there,
I have to queries as below
one which shows a few stats figures etc all on a single row but has 6 columns altogether
the other shows some figures by function area and as there are like 7 function areas there are 7 rows but only 2 columns
i want all this informaiton onto one report so i guess that i need to merge this data together onto the one query some how
whats the best way to do this?
thanks
View 2 Replies
View Related
Jul 6, 2007
Jus thought I'd offer this code to the forum as spent a long time finding a suitable solution..
SELECT DischargeTime.ID, [Arrival Times].ID, [Arrival Times].[A&EArrivalDate], [Arrival Times].[A&EArrivalTime], DischargeTime.[Date of outcome], DischargeTime.[Time of outcome], DateDiff("d",[A&EArrivalDate],[Date of outcome]) AS DateDifference, [Time of outcome]-[A&EArrivalTime] AS TimeDifference, IIf([DateDifference]>=1,([DateDifference]*(1/24)*576)+[TimeDifference]*(1/24)*576,([DateDifference]*(1/24)*576)+[TimeDifference]*24) AS hours3
FROM DischargeTime INNER JOIN [Arrival Times] ON DischargeTime.ID = [Arrival Times].ID;
Basically I had an admission date and in a seperate box an admission time and then I had a discharge date and discharge time again in seperate boxes. The information was spread over two tables hence the join. How I solved the problem was by gaining both the days difference between and then the difference in hours and then I created an iff function and played around with it till it worked. Dont really know how i got it working in the end but it does so hopefully this code will save some1 alot of time!
(I know that if id shown my dates as date/time in 1 box the problem would have been much easier solved, however I dont personally like displaying dates and times that way especially when you have inexperienced people entering data)
Find below a result from the query
DischargeTime.IDArrival Times.IDA&EArrivalDateA&EArrivalTimeDate of outcomeTime of outcomeDateDifferenceTimeDifferencehours3
1119/06/200715:0420/06/200712:00103:0420.93
View 2 Replies
View Related
Apr 10, 2007
Is it possible to fill an unbound text box in a seperate form with some text "Warning.HIGH RISK" on the click event of a checkbox on a different form?
View 2 Replies
View Related
Nov 9, 2005
OK this may be a bit of a weird one.
Here are my tables:
Table: Relationship
PK: RelationshipID int (Indexed No Dup)
FK: ContactID int (Indexed No Dup)
Table: Contact
PK: ContactID int (Indexed No Dup)
FK: RelationshipID int (Indexed Dup Allowed)
I also have following Local vars:
@Contact1 int
@Contact2 int
How do I create an UPDATE statement that will read RelationshipID in Relationship where Relationship.ContactID=@Contact1 and use it as the value to update the Contact.RelationshipID for all records in Contact where Contact.ContactID = @Contact1 or @Contact2
Hope this makes sense?
Also please let me know if I should post this in the SQL area instead.
View 1 Replies
View Related
Aug 4, 2007
I have a form setup that has 5 combo boxes where a user will select one item from each combo box. Each combo box is from a differant table. Once this is done I want to be able to append or update the results into a new table I created. My problem is I don't know how to submit the data from the combo boxes to the new table. Can anyone help me with this?
Thanks
View 11 Replies
View Related
May 3, 2005
I'm new to Access. I've created a master table called "People". It contains all data of all people. There are different types of people and their values (and a people code that I created) distinguishes their types. One type of person (a customer) has a value called "ProjectNature". I created a "ProjectNatureTable" that contains project nature codes (PTF is Pressure-Treated Fence; CD is Cedar Deck, and so on). When editting the "People" table, users can pick the projectnature code from the combo box, and the ProjectNature value appears in the People table for that customer.
Table 2 is my "Project Initiation" table. It needs to be able to plug in the "ProjectNature" value from the "People" table for existing customers. All Access will let me do is pick the ProjectNature from the combo box list. It won't read the value that's in the People table for each customer. I don't want my users to put in a Project Nature code in the Project Initiation table, in case they pick the wrong code for that customer.
How do I get my 2nd table to read the value (not the combo box) in the ProjectNature field in the People table and automatically put it into my 2nd table?
View 1 Replies
View Related
Aug 13, 2005
Hi there,
I'm working on a small database for my girlfriend and I to use for tracking some products for a home business.
We are the only two who will use it.
I've created the database in Access 2000 on windows XP pro with sp2.
Everything works great in the database.
Problem is sharing it. I shared the folder I created the database in (c:databasesite) ... In the folder is "products.mdb" and a folder called "Images"
Basically, I just want either of us to be able to open the mdb file and enter new data/make changes/whatever... both users need full access.
The shared folder has permissions set for both users to be able to read/write.. and both users can read/write to the folder.
BUT... when my gf tries to open the .mdb file from her pc, she gets a message saying that it's already open exclusively by another user. Only thing is, no-one else had the file open at the time.
The database is set to open in shared mode by default, so that's not the problem.
I can even go one step further to say that if I copy the .mdb and images folder to the default windows "Shared Documents" folder, everything works peachy for both users... both can get in and edit stuff... even at the same time... so why the heck wont it work in any other shared folders?
Is there some step i'm missing with this one?
Plz help!
View 1 Replies
View Related
Mar 14, 2006
Im not sure how to go about this, so I need plenty of advise. The Database I have built is, at the moment on a number of laptops, none of which are contected to a network. If things go according to plan the DB will eventually go on to the desktops which are conected. the aspiration is that the DB will be on one main PC with all others accessing it. Problem is I have never done anyting lke that before and am unsure where to start. alny advis gratfully received. Thanks!
View 4 Replies
View Related
