Seth,
That's brilliant - wish I'd thought of it. Will try it now and let you know. Thanks for the reply,
Stonward
stonward
Last Activity: Jan 21 '16, 02:25 PM
Joined: Jun 29 '07
Location: Bristol, UK
-
stonward started a topic Why is Linked Table Manager not available when database is moved to another machine?in AccessWhy is Linked Table Manager not available when database is moved to another machine?
Good day All,
I've made a very simple hardware tracking system that the company I work for now want to roll out company wide (gulp). I'm using Access 2010 (I'm used to 2007) and a 64bit machine; I've split the database, but when I install the frontend on another PC the linked table manager is greyed out.
Thing is, even when I try to install an unsplit version with the tables present - the linked manager is still not... -
Hi ZMBD,
Yeah, no apparent issue. The default query the listbox opens with
"qry_SearchedSt ockR" is what comes up with debug.print, including adding a debug command at line 3.
StonwardLeave a comment:
-
Hi Seth,
Ha Ha! That's exactly what i told my user; "Stumped"! Here's the code I'm using at the moment. "Trade Note" is simply a label that says 'Trade Price Only' and I use it's Visible property to gauge which pricing I'm on...
...Code:If lblTradeNote.Visible = False Then Me.lblTradeNote.Visible = True Me.cmdPricing.Caption = "Retail Pricing" If List55.rowSource = "qry_searchedstockR"
Leave a comment:
-
Hi Seth.
The immediate window shows the current query underlying the listbox ("qry_SearchedS tockR"), which is simply all products in stock and showing Retail price. And it's correct. If I change the listbox query, the Select Case debug statement is always correct. It just doesn't CHANGE the rowsource as it needs to.Leave a comment:
-
Using Select Case to change ListBox RowSource
Hi Folks,
I have a listbox listing my products. The listbox rowsource changes depending upon the user's selection of exactly which products to list, and in addition there are two pricing structures, trade and retail. I have this working quite well using If Then Else, but there is surely a more elegant solution using Select Case. The following code always jumps to Case Else, although I know thru debug that each case is evaluated and... -
Hi Fellas,
Sorry for the delay - no internet!
Zmbd - I have no control source for the first combobox (it's unbound, tho I did try binding it); the RECORD source (for the subform) is a query, but if you mean RowSource it's a simple select statement against a one field table (manufacturers) , the type is Table/Query and the bound column is '1' (there is only one. Let me know please if something is different in 2010.
...Leave a comment:
-
Using linked combo boxes in continuous forms setting...
Hi All,
In a details subform I have two combo boxes, the second based upon the choice made in the first. So, the user chooses a manufacturer in the first box, and this narrows the choices available in the second.
Everything works just fine, but when a manufacturer is selected in the first combo, all the 'first' combos change - on each line - to the same setting!
The record is saved in the table correctly,... -
stonward replied to What is the syntax for an update table field to a variable based on another variablein Accesshi Seth,
Now I didn't know about the space! I saw it in an example just before I read it in your answer. And guess what, it makes a difference!
Thanks yet again.
StonwardLeave a comment:
-
stonward replied to What is the syntax for an update table field to a variable based on another variablein AccessHi Seth,
I can understand using the query window to get the SQL and then convert to VBA format (tried it!), but I don't quite get what it is you're doing in your example. What is the difference between strQuery, your variable and, say, strSQL as a string variable for the SQL?
StonwardLeave a comment:
-
stonward started a topic What is the syntax for an update table field to a variable based on another variablein AccessWhat is the syntax for an update table field to a variable based on another variable
Greetings All.
I am trying to find the syntax for an SQL Update Table instruction. They're quite straightforward it seems until you try to use variables as criteria.
So, I want to update the Diameters field of my Products Table to the Diameter value on my current form, only updating the record of the ProductID from my current form.
...Code:"UPDATE tblProducts SET Diameter =" & intDiameter
-
Hi again.
Something is wrong with the update SQL/query (above). I altered the SQL to take account of what looked like a glaring error that Neopa found. The stocklevels get updated, but i also get a parameter query input box asking me for input. Clicking OK (no input) updates the stocklevel.
But when I look at the (update) query that the SQL is based upon, I can see no errors. Thethat appears to be an...Code:Products.Stocklevel
Leave a comment:
-
Ha! Spotted NeoPa. And so obvious...now.
Altered to where clause from stocklevel to productid and the update works, but is still very slow. Am I missing something more fundamental I should be looking at?
Thanks for finding that; I couldn't find it.
Regards
StonwardLeave a comment:
-
stonward started a topic What is the syntax for getting a function's result into a query's criteria?in AccessWhat is the syntax for getting a function's result into a query's criteria?
Hello Again All,
Forgive me as I try to be brief:
I am using a modified version of Allen Browne's excellent 'onhand' function for calculating stock levels 'on-the-fly'.
The function works perfectly, however I need to show stocklevels for a number of items on my 'home' form and found that the onhand function is way too slow to allow that. My solution is to 'reflect' the onhand results via a query into my products... -
Hi Guys,
NeoPa's is the best (most correct?!) answer methinks, but i have used Seth's purely because I know and understand those particular domain functions rather better.
But neoPa's idea will find its way into my first update, I feel certain.
As always, great thanks for your time and patience,
StonwardLeave a comment:
-
NeoPa; You've just taught me something new. I didn't know you can call a method like that. Be assured I'll be using that!
Many thanks again,
stonwardLeave a comment:
-
TheSmileyCoder: spot on - that did it...make button public, make sure everything is fully named/called in the originating code. Now my listbox updates automatically!
Super Thanks,
StonwardLeave a comment:
-
Thanks TheSmileyCoder. I tried making the button event public, now going to check I've done that AND fully qualified all names.
Get back to you.
Thanks again,
StonwardLeave a comment:
-
ha ha! Yes, and for anyone else listening, have a firm naming system. I have, but I slip sometimes when I'm fighting to get something done - and I pay for it every time!
Thanks guys,
stonwardLeave a comment:
-
The button on the 'main' form, cmdReset has a click event attached to it and works correctly. Looking back at what I've done before, it would seem I've called 'that' (a) buttons click event from another button on the same form, where simply entering cmdReset_Click works. I thought if I qualified everything I'd be able to do the same from another form, but doesn't look like its possible.
Interesting point about calling procedures from...Leave a comment:
No activity results to display
Leave a comment: