Amy Badgett
Last Activity: Jun 3 '11, 03:32 PM
Joined: Feb 15 '11
Location:
-
Got it working. Thanks for all the help. -
Thank you for the detailed instructions. I have Windows 7, so the network connections I guess is now network and sharing center. Things are set up differently, is there any way you could give me instructions for setting up this connection for Windows 7?Leave a comment:
-
Cannot connect to IP address for set-up wizard.
I am trying to set up my D-Link DI-624 router. I downloaded a manual, and it instructs to connect to 192.168.0.1, but I'm not able to do this. This address should be getting me to the set-up wizard which should then I guess help me set up wireless internet access from this router.
I ran ipconfig from command prompt, and the Default Gateway is different from 192.186.0.1. (Is it safe to let people know what IP address your computer is... -
Thank you, NeoPa, this was helpful, and the code is working now.Leave a comment:
-
As far as I can tell, this is the only problem. I will implement the Case statements as you've suggested and let you know the results, and if any other controls are giving me problems.
Thank you!Leave a comment:
-
For example, when I chose "Cased DVDs" line #31 is highlighted. Sorry for the confusion.Leave a comment:
-
Run-time error '438' (Help with VBA coding)
I have been getting this error:
"object doesn't support this object or method."
The debug is saying the problem is in the series of if statements based on which product I enter in the "drpProduct " control on the form. (Lines 26-48)
...Code:Private Sub btnSave_Click() 'Automatically sets the Location of the transaction to SSP. -AJB 4/13/11 Me.txtLocation = "SCP" -
Proper syntax for using an update query in VBA?
Could anyone give me the proper syntax for executing a SQL Update Query in VBA in an on_click event?
Maybe like a step-by-step explanation? -
Thank you, that was helpful advice, and my update query is now working.Leave a comment:
-
So, I'm guessing this code either looks right to most people or more information is needed to help me out.
I would suppose the query would be self-explanatory, but if it isn't, here is what I need from this query.
I need to set the tblCallLog_ship mentID field to the next shipmentID number (which I found in another query by selecting the maximum shipmentID plus one) where the clientID's of the callLog table are the same as...Leave a comment:
-
SQL Update Query that references another query and another table
Access is saying that this query is not updateable. Can anyone tell me why?Code:UPDATE tblCallLog SET tblCallLog.tblCallLog_shipmentID = (SELECT [queryNextShipmentID].[Next ShipID] FROM [queryNextShipmentID]) WHERE ((tblCallLog.tblCallLog_clientID In (SELECT ListTop.tblCalLLog_clientID FROM[ListTop])));
-
No, the IDs are on the same table (Call Log), and I didn't think I would need any joins unless I was wanting to reference another table.
Does anyone else have any other ideas on this?Leave a comment:
-
Thank you, Stewart, that is exactly what I needed.Leave a comment:
-
How to reference a control on a form in a DCount on the same form?
I need to count the number of occurrences of a particular employee based on the type of occurrence selected in a control drop down box. I am using a DCount on the same form to try to accomplish this.
Can anyone help me with the syntax of this DCount:
...Code:countOfOccurrence: DCount("Resolution","tblIssues","[tblIssues.Resolution] = Forms![subFormOccurrence].[drpResolution]") -
Amy Badgett started a topic How to put a negative sign on a number based on the selection of a drop-down list?in AccessHow to put a negative sign on a number based on the selection of a drop-down list?
I would like to create a form that allows users to enter in changes in transactions of inventory.
Is there any way the number entered into a control text box can automatically have a negative sign come before it? Or could I base the fact that there is a negative on the number on whether a drop-down box control has "inbound" or "outbound" selected? -
This makes much more sense, thank you.
Another question, I would like to create a form that allows users to enter in changes in transactions. Is there anyway the number they enter can automatically have a negative sign come before it? Or could I base the fact that there is a negative on the number on whether a drop-down box control has "inbound" or "outbound" selected?Leave a comment:
-
Yes, that makes sense. Thank you for being gracious with my limited knowledge. A transaction table does sound more like what I need.
I don't understand: "Instead, the item would be linked in a query to all the related transaction records, and the sums resulting would be the values displayed indicating the stock levels."
What I need to know is how to create a new record on a table based on the last updated transaction...Leave a comment:
-
Amy Badgett started a topic Inventory Form that adds/subtracts from current inventory number in tablein AccessInventory Form that adds/subtracts from current inventory number in table
I am currently trying to create an inventory database that includes a form that will update the inventory numbers last updated in the database. Rather than having one row constantly being updated in the table, I would like to keep track of what has come in and out of the warehouse and when.
So far, I have the fields on my form and am able to update the next record by entering in numbers, but I'm not sure how to use what I enter into... -
Access SQL error "Overflow"
I keep getting the error: "Overflow" with this piece of MS Access SQL coding:
...Code:SELECT DISTINCT (SELECT Count(tblCallLog.tblCallLog_gospelPresented) FROM tblCallLog WHERE tblCallLog.tblCallLog_callDate = Date() AND tblCallLog.tblCallLog_callDate Is Not Null AND tblCallLog.tblCallLog_gospelPresented = true) AS todaysGospelPres, (SELECT Count(tblCallLog.tblCallLog_gospelPresented) FROM tblCallLog
-
More than one query to a form?
Is it possible to use more than one query on a form?
No activity results to display
Leave a comment: