Search results for query: *

Hello, I did a search and found a post that dhookum pointed to a Dynamic Crosstab ... FAQ703-5466 I was hoping I can get some help with that. I don't understand if you need the form for the date. I have a report that calls out a query which is based on two cross-tab queries. So the columns are...

I have a query where it pulls the last ReceiptNumber from ReceiptHistory. I was hoping someone can help me on how I can have the last ReceiptNumber increase by 1 on change of the PO Number. Example: the last ReceiptNumber say is 12345 So in my query it says: ReceiptNo...

Hi, I can't figure out how to parse information from a field. Here's an example: FinishingHours P7STF 4.50 STONE FINISH 2.00 STONE FINISH 3.00 STONE FINISH 4.00 They decided to add hours to the description. I need to parse out all the numeric values and then delete them once pulled and...

I have a form with certain fields defaulting to certain values. The end-user would like to change the default value. Meaning, LaborRate field is defaulted to $12 so for every quote entered the LaborRate automatically has teh $12 value. The end-user would like the ability to change it, let's...

hope this is the correct posting. I need something to count (two digits 00-99) per date and by per user. So, if I enter a quote I need that quote for today to be 00 and the next one to be 01 up until 99. BUT if another user enters quotes on the same day, the count should restart with 00 for...

I've never seen this in all the years of working with Access. I have a database that was working fine and the next day everything is gone except for the file name. The file shows 1900kb of data. When you open it there is nothing. No tables, queries, forms, reports, modules. How can this happen?

I can't figure out why it won't apply the CustomerID to my Quotes. I have a form for the main Customer information. Then a button to open a form to enter quotes. The Quotes table has QuoteID and CustomerID. When the form loads from the Customer form and the quote information being entered, it...

Ok, I have the following in my form: CustomQuoteNumber: Format([EntryDate],"yymmdd") & recordnumber & [EnteredBy] It's a logic based off of: 1. Entry Date (actual field) in the yymmdd format then by 2. Record number of the day which needs to always begin with 01 each day and by each user. This...

Ok, I have the following in my report: CustomQuoteNumber: Format([EntryDate],"yymmdd") & recordnumber & [EnteredBy] It's a logic based off of: 1. Entry Date in the yymmdd format then by 2. Record number of the day which needs to always begin with 01. This gives 99 orders per day per user. 3...

I have this in the ReportFooter =IIf(IsError(Sum([SumOfBalance])),0,Sum([SumOfBalance])) and I still get #Error# I have =IIf(IsError([SumOfBalance]),0,[SumOfBalance]) in the detail and it works. I don't know what I'm doing wrong for the Grand Total in the Report Footer. HELP!

Ok, I have a query that pulls data from a master list. The master list has the parent sku. I have another query with the totals for the parent sku level as the data is for the components. So I need the query result to show all records from the master list except when the items match in this...

Hi, I can't figure out how to edit this module to process from two separate list boxes. This module runs from selection(s) from a single list box. I also need it to process selection(s) from another list box named "RepSelector" from the query "SalesRep" Can someone help me? Here's the...

Hello, I can't seem to figure out how to give a 0 value if the subreport results in a null value. I have a report with several subreports which are based off of queries. Some months there isn't any data in one or more of the subreports and I need it to return a 0 value instead of a null...

Hello, can anyone tell me where I can go to download the drivers for a Nokia C020 Wireless LAN Card for WinXP?

I keep getting [ODBC Microsoft Access Driver] invalid character value for cash specification on column number 10 (QOH) This is a template that's been used for almost year and now I am getting this and can't figure it out. You can see the results in the query editor in Excel You can run the...

Can you share a schedule/activity with other users? It seems that you can only assign one user but I would like my other users to view this activity without having to create the same activity for the multiple users. hope that makes sense and it is possible. thank you!

Hello, I can't figure out what's wrong or what else to add to this Item: IIf([SKU] Like "WS*","LSM" & Right([SKU],3),"SCONCE") The issue with this is that it's putting everything else to SCONCE even when the SKU isn't like WS* Can you help?

where there's a change in another field. Ok, i have a query and I want it to NOT show the SKU and the information for that sku again IF the WHSE changes. Here's what I currently have and not sure how to limit it to do the above. SELECT NegativeOnHand.TransactionDate...

Hello, I can't figure out the OLE Object. It's not working for me. I have a field in a database (SQL Server table) that stores the image name. example: logo.jpg I have created a table in MS Access of the fields I need including the image field but added the path with the image name of only the...

Hello, This seems to be an anomaly (at least for me) :-( I don't understand why the worksheet is pulling data from the .mdb data source when it is refreshed with data that does not exist in the Access query that it's importing from. I thought I fixed it last week but it's doing it again this...