Recent content by Cowboy_BeBa

  1. C

    Use of wifi capable barcode scanners with an access db

    interconnected routers Basically if you log onto the wifi in one warehouse and take your phone to the other warehouse youll still be connected to the wifi and hence the rest of our network
  2. C

    Use of wifi capable barcode scanners with an access db

    Hi all, Back again for some more wisdom from you guys So my companys custom access ERP database is due for another update. I've been building and improving upon it for years thanks to help from this page and now is time for a big one. Basically they wanna start scanning in barcodes for all...
  3. C

    access on an ipad?

    Hi all Recently ive been put in charge of running a commercial bakery thats owned by the company i work for not my usual field of work (im their local db admin), but they needed someone familiar with the operations to take over from the old manager ASAP and i was the only one who could do it...
  4. C

    mysql date add with query for the interval

    lol, sorry to sound like a smart ass but first word of the threads title youre right though, i shouldve mentioned it in the main text
  5. C

    mysql date add with query for the interval

    nope, this is mysql, its dateadd(date, interval x day) as i said i tested the first query UPDATE tbl_batches SET StartDate = DATE_ADD(StartDate, INTERVAL 3 day), EndDate = DATE_ADD(EndDate, INTERVAL 3 day); and it worked perfectly, so not the notation and its not the data im testing its the...
  6. C

    mysql date add with query for the interval

    the page im testing is meant to only show data with a date range from now() til now()+7 days (basically records in the oncoming week) so most of the records today wont be valid tomorrow and will not show up on the page at all i could change the query but that defeats the purpose of testing it...
  7. C

    mysql date add with query for the interval

    hi all im having a bit of trouble creating a query to help me keep my data up to date basically im testing a page ive built that displays data within a certain date range, ive got queries to populate my tables with relevant test data but the problem is keeping this data up to date. I wound up...
  8. C

    working with MVP and creating a Filtered Detail List

    Hi All Just a bit of background before getting started, ive been developing access databases for years and consider myself very proficient in them. Recently ive looked into rebuilding a DB i made for work into a web app and selling it off to other companies (work is cool with this as i made...
  9. C

    Tricky query Criteria, between dates if textboxes are null

    thanks guys, tried implementing your solutions with no luck i do prefer CJ_Londons Solution so ive sorted it out so that the text boxes autopopulate with the current date and the current date minus 3 months that part works fine but then i use the following expression for my query criteria...
  10. C

    Tricky query Criteria, between dates if textboxes are null

    Hi all So i have a report that, among other things, shows us stock ordered between today (the current date) and the last 3 months. The query criteria under the date field is as follows: Between DateAdd("m",-3,Date()) And Date() nice and simple and works perfectly However now there is a new...
  11. C

    delete query, delete duplicates but keep one

    Hi all Im working with a large list, over 30k records and (frankly) its driving me a lil nuts i had to create a cartesian join on a single table, so i could get a list of two similar records on one row and make it easier to compare the two (looking for similar records that may be duplicates)...
  12. C

    enabling/disabling features on custom ribbon

    Hi all just working on a mock up of a database for the organisation im working for. they havent agreed to let me build it just yet but im going to meet with the bosses next week and try to pitch it for them. Their old DB is garbage (alot of people were excited when i was hired to fix it) and im...
  13. C

    "Fat Fingering" Query

    can anyone explain how i can put the function (from post #10) to use? have two tables (tblMasterList and tblDatalists), all have exactly identical fields (did this on purpose when i was compiling tblDataLists) to make sure it would be easier to merge the two lists when the time came...
  14. C

    finding similar records across two tables

    DUDE!!!!! That is some next level shit right there thank you so much for your help!!! it is very much appreciated
  15. C

    finding similar records across two tables

    trying to fix up a massive db (over 40k records) that is a real mess (duplicates, blank records, mis-spelled stuff, you name it and im dealing with it) right now trying to update data ive got from one list (which ive imported as a table) into the main list there is a primary key in the main...
Top Bottom