Search results

Hi I am trying to extract all numbers before a space, no problem with LN: Left([Custom label],InStr([Custom label]," ")-1) Except this will return #Func! where there are no spaces after the number Example 1234 yth will return 1234 but if the number has nothing after it i.e 2456 I get #Func...

Hi I am trying to copy a single record from one table to another Heres what I have I have a suppliers table, suppliers order table and suppliers orders detail table I use this to generate an order for the supplier, however the single order does not always arrive at the same time (the order is...

Hi I am trying to get the info for sales from last week (ending on Saturday and new week starting Sunday) and this week starting on Sunday case 4 and 5. For some reason I can easily go back 7 days from today but not last week that ends Saturday I am really struggling with this Heres what I...

I have been having problems trying to link access form field to a word form field. Word is opening as it should but the field is empty. I am trying this with a blank word document with only the 1 linking field txtTitle and the name of the db field is frmTitle I did notice that the word document...

Can someone please point me in the correct direction I am trying to change the button color on a subform if a related form data changes Main form is products with a continuous subform with serial numbers of products i.e, serial number, location, price and a button to add addtional issues if...

Can someone point me in the right direction to filter reports by specific date types in a drop down or combo box I would like the dates to be Today Tomorrow The next 3 days and the next 7 days i don't want a date picker or between dates I have tried searching but cannot seem to find an answer...

Hi I am trying to use a formula that I am using in excel and cannot seem to translate it to access. The excel formula is =IF(A1<=20,10.45,IF(AND(A1>20,A1<=30),((A1-20)*0.35+10.45),(A1-30)*1+(10*0.35)+10.45))*1.255 Thank you Mr Excel for your help on that I am trying to use it like this Cost...

I would be grateful for some help on a default value in a table. I use an empty table with a couple of fields with default values in i.e. category: (default value is) Home, image url: (default value is) www.domainname.com/images/ I then append a query to this table which will then be exported...

I am trying to calculate the sales figures using the formula below which gives me the sales results for June 2009 but for some reason I cannot seem to get it right to give me the results for May 2009 and April 2008, can anyone give me a pointer please. =DSum("Total","AllSales","[OrderDate]...

Hope someone can help. I have a form with a few general stats from my table "AuctionSales" I can summarize todays and yesterdays sales ok but I am having trouble summing up this weeks sales and last week sales I have this so far but I am missing the point somewhere...

Hope you can help I have a combo box on a form based on a field (serialnumber) in a table as below. All numbers are unique and once chosen will never be used again. How can i hide the numbers in the combo box that have been used before? i. e. when the code 1001 has been used all you see the...

I am using Access 2010 and have a question about the web browser control. I have inserted the control on a form and it navigates to a site and searches for the information I require. The issue is that the response i need is always in the same place about 1/2 way down the page. Is it possible to...

Can someone help me with grouping. I would like to be able to run a report for certain days of the week this year against last year. In other words I would like to see lets say sales just for Saturdays in 2010 (not grouped together but individually so I can plot a graph) and then see how they...

Hi I am trying to display last month by name in a field. I can display this month with =Format(Now(),"mmmm") but I can't seem to get it to show last month even with -1 Any ideas Thanks Kim

Hopefully someone can guide me in the right direction. On my forms I have the customers info and the products they have purchased along with Sub-total Delivery Discount VAT Total When my invoice prints it has all of the above fields. What I would like to be able to do is to suppress any field...

I am trying to pull records from today to the end of the week, when I try the code below I get everything from this week, can anyone advise me. DatePart("ww", [ApptDate]) = DatePart("ww", Now()) and Year( [ApptDate]) = Year(Date()) Thanks Kim

Not to sure how to do this. I have a customer form which I obviously enter customers details on. There are times when we do a small cash sale and want to bring up the customer called "cash sale". Can i do this with a button? as it is always the same record we use for this purpose. It...

Hopefully someone can point me in the right direction. I am trying to highlight a matching row in a subform from the main form. I have a popup form (mainstockform) with a subform (addinventory) to enter existing products into the db stock, when entered it updates another subform (currentstock)...

Not sure why this seems so difficult for me to fix. Have a field OrderDate which carries dates of sales. I am trying to group the date into days Currently I have OrderDate SaleAmount 6/6/08 100 6/6/08 150 6/6/08 120 7/5/08 130 7/6/08...

Hope someone can point me in the right direction. I am trying to refresh a form from another form, here's the scenario. frmCurrentStock has all of the current stock and from time to time I need to add new stock items. I have a button that opens up a frmAddStockItem for me to add a new stock...