rdsandy
Last Activity: Jul 14 '08, 02:49 PM
Joined: Oct 5 '07
Location:
-
I fixed all the current threads to instant notification (by selecting them all and setting them to instant notification from the drop down box at the bottom), but will new threads have notifcations on do you know? -
Sorry I didn't get back to this, I put this on the side for a while to do other things.
I did forget to put the links in, and have done that. What I was asking before was how to set the tableID field to a number for which ever subform I was in, so if the record was going into ProjectTechnica l, TableID would be set to 1, if the record was in ProjectCommerci al then TableID would be set to 2 etc. I forgot that you could set the default...Leave a comment:
-
9 Forms using only the one Table
Hi,
I am going to start off and apologise for the length of this post!
I have a form with 9 subforms on. Currently, each subform has its own table. Each of the tables have exactly the same field layout (ie: same fields, but slightly different names for whichever table it is). Here is an example of what I mean:
One table is called ProjectCommerci al(PC), another called ProjectTechnica l (PT). In these... -
cannot insert duplicate key row in object 'Table' with unique index 'Index'
Hi,
I have a table Risk, a table Mitigation and a table RiskArchive. I am taking the RiskID, Criticality and MitigationPlan fields from Risk, and MitigationActio nID from Mitigation and inserting them into RiskArchive, using a stored procedure. What happens is if there is no entry in RiskArchive for a specific RiskID, and the other fields relevant for it, then it needs to be archived, but also only if it is not duplicated.
... -
Im having a different problem with this stored procedure, but as its to do with a different error, I will make a new thread for it.Leave a comment:
-
The multi-part identifier "..." could not be bound
Hi,
I am using SQL Server 2005. I have this stored procedure below but it doesn't work. It is for an archiving process I am currently implementing. The RiskArchive table has fields ArchiveID (primary key), RiskID, Criticality, MitigationActio nID and ArchiveMonth (datetime data type). What I am trying to do is take the RiskID from the Risk table, the Criticality (a number showing how severe the risk is) for that risk and also any... -
Hi ElTipo,
I haven't used the send object before, but you say it won't work because your using the comma in a way to send two reports in the one line of code. If you put a comma in between TEST1 and TEST2, wouldn't it give the next criteria for the DoCmd.SendObjec t command?.
If taking out the TEST2 works (see below for an example), then you could try having 2 command lines, one for TEST1 and one for TEST2.
...Leave a comment:
-
CWilliam912, if its a programming assignment, you will have a tutor of some sort (whether at work, university etc) who gave you this problem and will therefore know the answer. Why not ask him/her first, not for the answer but for advice? Also a C++ book will help you greatly aswell.Last edited by sicarie; Mar 17 '08, 12:33 PM. Reason: thread hijack removed, response to hijacker removedLeave a comment:
-
Check if user clicked certain button on previous fom
Hi,
Im using Access 2003. I have a form, with two buttons and a list box. When a user selects an item in the list box, the user clicks on one of the buttons which opens up the selected record. The other button is for adding a new record. The form that opens up has a subform within a subform on the form, and at present it doesn't open up on a new record (the sub subforms). In vba code, how would you bring up a message box on form... -
After re-reading your post, it sounds like you have both forms open at the same time. I just made a dummy database, made two forms, one called Location, with a text box called Location, and a command button called cmbCopy, and another form called Designator with a text box called Designator. I made a new module and the code in there looks like this:
...Code:Option Compare Database Global copyText As String
Leave a comment:
-
Hi Hitman,
Im not sure how you set up your global variable and how you used it, but i'll suggest how I do it. Make a new Module (by going on the Module section of the database window and clicking new). Then type in:
where yourVariableNam e is the name of the variable, and yourVariableTyp e is the data type for it (ie: for text use String etc). Then...Code:Global yourVariableName As yourDataType
Leave a comment:
-
I sorted this out now. I removed the record source completely from the 2nd form being opened (which was the table for the form), ran the program, then put the record source back in, closed and reopened the database and ran the program again and it worked. I think Access got lost on what variables it had when I had errors trying to solve it.Leave a comment:
-
DoCmd.OpenForm problems
Hi,
I am using Access 2003. I have a list box on a form which has 6 columns in it, with data taken from a table. I have an unbound text box which holds the ID number for the selected item in the list box. I have a command button which I want to use to open another form on that record. At the moment it opens the other form but only to the first record. The other form has its recordset set to the same table as what the list box... -
Sorry I didn't reply sooner. Yes I do have it like that but it only inserts the old data, not the new data.Leave a comment:
-
Hi Denburt,
I tried with both lines in and I got an error message saying "The command or action 'InsertQueryCol umn' isn't available now" on the acSelectRecord line, and if I take that line out then it still does the same as before.
AndrewLeave a comment:
-
"Archive" process not working properly
Hi,
Im using Access 2003 and SQL Server 2005. I made a stored procedure to do an archiving process, which if theres a change in a certain field, it inserts the certain fields in that row to an "archive" table. The stroed procedure is below:
...Code:alter PROCEDURE [dbo].[usp_RiskChangeArchive] @RiskID int AS BEGIN SET NOCOUNT ON; insert into RiskChangeArchive
-
Access form field view window
Hi,
I have a subform Risk linked to a form Category, in a database called RiskAnalysis. I am using Access 2003. In the subform (which is in datasheet view as the user who will be using this wants it in that view), there are quite a few fields (17 in total), and as you can imagine, trying to fit them onto one view (ie: not scrolling across) is quite impossible with seeing the data aswell.
What I would like is when the... -
oh yes sorry, that does need to be in there!Leave a comment:
-
Just to maybe explain it a little more, if for example I stuck 1 in the where criteria (locID being 1 and loc then being london), the crosstab query shows the results for london, and then puts london in place of the rs!Location (as it puts 1 into it, but puts the relevant location instead of the number).
Im sure you know but the query design is like:
Field: LocID
Table: Location
Total: Where
Crosstab:...Leave a comment:
-
Access 2003 crosstab query where criteria as increment
Hi,
I have some code below in VBA for Access 2003 which is on a button called "RentalCrosstab PercTtlQtyMonth Loc_Click". This is a crosstab query which brings up rental items down the side, who rents along the top, the rental month and total number of each item on that month as rows next to the item, something like this:
Item TotalQty Month Renter1 Renter2 ....
PC 234 ...
No activity results to display
Leave a comment: