Search results

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

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

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

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

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

Hi So ive rebuilt my work database the original db had 3 tables for keeping track of Stock (tblFinishedGoods, tblProducts, tblIngredients), the new one just has one table for all types (tblStock). This new design simplified the crap out of all the queries i used to calculate stock costs/levels...

Hi Thanks for taking the time to read this, first off appologies for the title, i dunno how accurate it is but i honestly could not think of a concise way to explain what im trying to accomplish Currently im looking into adding an audit trail into my db (long story short a lot of data is being...

hi all ive made a report that is basically just a purchase order sheet the issue is several purchase orders can be generated at once (i force a new page after the record finishes) so as a result the default "Page X of Y" label has X as the current page number and Y as the total number of...

Hi all This is a bit of a random one and i hope you guys dont mind if i ramble on a bit, because even though the question is simple enough im not sure if im approaching my problem the right way (ie, not sure if i even need to worry about saving changes to a form property..... which i think...

hi all im trying to open the windows filebrowser (preferably to a specific folder, if folder doenst exist then it can open to wherever) Once the user selects a file id like to be able to store the filename and path in a variable and mess around with it later (preferably would like to store the...

Hi all Im currently looking to take my access DB's to the next level. Going to start going with a mySQL back end and a web browser based front end (also looking into an app based front end later on) Ive worked with mysql servers before. But they were all in University, so the servers were...

So im mostly self taught when it comes to VBA but i do have some programming experience Usually when im coding a form ill define all my functions in Private Sub's (i know i can probably set them to Public, but ive never really needed em to be accessed by other forms (i think thats what the diff...

hi all I'm building a login page, its Modal so cannot be clicked away the basic login function works well (compares username and password entered with that in a table and, if all values are equal, opens a main menu form) as the login form is modal i had to set its visibility to false so that...

Hi all I have a subform thats essentially just a Bill Of Materials for a list of products (which are on the main form) so selecting a product on the main form allows you to view/add the products bill of materials in the subform, very basic the trouble im having is that now i wanna add a...