Search results

thanks so muc, gonna try this out now and will let ya know how i go

Hi CJ Sorry for the late reply, yes you are correct, i used a bad example regarding existing stock, that is already factored in when the query calculates the required value (its actually the amount of ingredients required for our blending plan minus what we already have on hand plus the...

Hi All It's been quite a while since i last did DB work and having a little trouble adding a new module to my old DB. Basically my DB generates a "Shopping List" which my guys manually go through, it lists all the ingredients we need and the quantities for the months production. We then...

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

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...

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...

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

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...

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...

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...

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...

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...

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...

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)...

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...

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...

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

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...

Hey all, hows it going? Ive recently started up my own company (with a partner who is in charge of sales/marketing) and have built an MRP system in access My partner wants to switch over to an SQL backend/web frontend I dont have much time to get the job done (as i also have a day job) so...

Hi all So im working on a new version of my DB and wanna make sure its secure AF. I usually disable the bypass key and set it to be reenabled once i put in my username and password (specifically me, if any other users use their login details it wont work) In the past ive also added secret...