crazytegger
Last Activity: Feb 3 '09, 07:25 PM
Joined: May 2 '06
Location:
-
Thanks, that fixed both problems I was having. -
I have another problem now. FF doesn't like it when I assign a numeric "key" to my object. What am I doing wrong here?
Code:var stain = {}; var pearl = {}; stain.1 = 'stain1.jpg'; //This produces a 'missing ; before statement' error pearl.a = 'pearla.jpg'; //This works fine
I'm also having problem with using a variable as my object "key" value:
...Leave a comment:
-
Thanks for the help, much appreciated.
JustinLeave a comment:
-
Associative array key
I need help, im sure the solution is simple, but it's driving me nuts. Im trying to retrieve the value of js_array['pearl']['a'] using js_array['pearl'][selectedObj.sel ectedIndex]; where selectedObj.sel ectedIndex is a string value from a select box. I need to wrap quotes around selectedObj.sel ectedIndex for it to retrieve the associative key properly, but everything ive tried has failed. This works fine if the key is numeric, but fails if the key... -
Help with subform values
Hi, I'm having a problem checking fields in my subform. On the main form there is a save button. The subform is a continuous form of items with an item quantity field. I want the save button to look if any items have a quantity of 0. The code I have works fine if I have only one item with a quantity of 0, or multiple items all with 0 for the quantity. However if I have two items, one with a qty>0 and one with a qty=0 it doesnt display the message.... -
Thanks for the help. I enjoy seeing how many different ways there are to accomplish the same objective with code. I thought about the composite key method however, I wanted to keep the numbers sequential per user. Also, thanks for pointing out the fundamental flaw, I'm still trying to decide how to address this. I will reply back when I figure it out.
Thanks again,
JustinLeave a comment:
-
Please help with alphanumeric number handling
I'm creating a function that will autoincrement a purchase order number. The number is the logged in users initials followed by four numbers (eg. JC0001). How would I go about determining the highest existing number with the prefix of the person who is creating the new order?
Thanks, Justin
Here is my code, I apologize if it is a bit elementary:
[CODE=vb]Public Function GeneratePONumbe r()
... -
Access Reports, images, and faxing???
Hi, I have an access report that has 2 different images on it. One is embedded, and one is a linked image. The report prints to a local printer just fine. When I try to fax the report (using WinFax) it comes through all right but the 2 images are not on the fax. I tried importing both images into a word doc and faxing them and that worked just fine. Is there something im missing?? some property that needs to be set in order to transmit these images... -
Im dumb. please help.
For some reason I cant get the most basic operations to calculate in my program. Im sure its something painfully stupid but here it is.
Code:Private Sub Form_Load() Dim iLogFail As Integer iLogFail = 0 End Sub
...Code:Private Sub Command8_Click() If iLogFail = 3 Then MsgBox "works" End If iLogFail = iLogFail + 1 -
Macro programming?
How easy would it be to program a macro that would:
1 Go through each subfolder in a specified folder
2 Open a file where the filename is file##DOC.vlm wih the appropriate program
3 do a CRL+A and then a CTRL+C
4 Open a graphic program such as MS Paint and do CTRL+V
5 Save that file as a monochromatic bitmap with the name file##.vlm (## is an integer)
Please let me know, im supposed to do... -
access currency and decimals
Hi all,
Im having trouble with currency formatting and the amount of decimals displayed. Most of my stored values are pretty standard ($10.50). Some item have a 4 decimal place cost though ($.0025). I have the table formatted to store 4 decimal places but when using the currency format it drops the last two places of the value. Is there a way around this or do i have to use general number format for the table? I also dont want the... -
Querys and Null
Im trying to query a table for records where a productnumber field matches a string AND are marked as discontinued. I also want this query to include records with null productnumber values. My problem is that when I include the OR IsNull, the query returns all of the items with a null productnumber, regardless if they are marked discontinued or not. Any ideas? -
query question
Here is my query, im trying to filter items using a string but also including null values. I also give the option of searching current, discontinued, or all items. the problem is when there is a null value, the query displays that item regardless of the itemstatus im searching for. I hope this isnt too confusing. can somone help please???
If Me.ItemStatus = "1" Then
strcrit1 = "(((items.itemd iscontinued)=(F alse)))"... -
Anyone??? please help me out, this is the only thing not working in my project and then im done!Leave a comment:
-
I am viewing one order number with multiple items referenced by that order number. I have a pagebreak per order number. the item details are contained within the orderid break under the details break, its layed out just like northwinds is. grouping and everything is the same but it is only displaying one of many items that is associated with that order number. northwinds seems to repeat the detail section for each item record it is to display, mine...Leave a comment:
-
I have the grouping set up just like the northwind does
Grouped by
OrderID
ItemID
but it only displays one of the items from the orderdetailsLeave a comment:
-
Report Help
Im trying to create a report for a purchase order very similar to the Northwind invoice report. I have everything figured out except how to repeat the entries in the detail section of the report. I have all the order information except all of the items. It will only list one of the items in the detail section, where in the Northwind report it repeats it as if it was a continuous form. Ive checked all the properties and they all seem to be the same.... -
yeah, that helped, thank youLeave a comment:
-
Why is this returning a "false" value???
Dim strSQL as String
strSQL = "SELECT items.itemid, items.itemname, items.itemsuppl ierid, items.itemdescr iption " & _
"FROM items " & _
"WHERE " & Me.cmbSearchFie ld Like Me.txtSearchCri teria & "*" & _
"ORDER BY " & Me.cmbSearchFie ld & ";"
Me.lstSearchRes ults.RowSource = strSQL
I dont understand,... -
Help with subform filtering
I am trying to filter a subforms combolist options through a combolist on the main form. Heres what i have:
Form: frmOrderDetail
Datasource: tblOrders
cmbOrderSupplie rID w/ control source orders.[ordersupplierid]
Subform: frmOrderDetailS ubform
datasource: qryOrderDetails
cmbItemID w/ row source:
SELECT [items].[itemid], [items].[itemname]
FROM items
WHERE items.[itemsupplierid]="&...
No activity results to display
Leave a comment: