Search results

Hi all, Could really use some help with my VBA code, I'm trying to add all the records of one table (tasks) to another (employee_tasks) using a while loop. The main field that needs to be added it the task ID but at the moment it keeps crashing when I try and run it which I'm pretty sure is...

Hi all, I'm having a bit of trouble with the VBA side of access. I have a subform that i'm using VBA to perform a specific calculation (inventory), i can do that no problem but when i do this it's only being applied to one row in the subform when i want to to apply to all of the rows. So the...

Hey guys So im trying to make a duplicate of the Northwind sample database as a learning task to help me get better at using Access and VBA. I have run into an issue with: Private Sub InitFilterItems() Me.lstReportFilter.RowSource = DLookupStringWrapper("[Filter Row Source]", "Sales...

Hi all, I'm currently creating an inventory system database for my company. the company i work for is a manufacturing company that builds kits for cars. I've currently created a very basic inventory system which works well i.e when a kit is processed it automatically adjusts the stock levels...

Hey All Was wondering if there was a way to code a checkbox to move a specific line of data once its checked complete If so, i would appreciate any help i can get :) Cheers, Rhys.

Hey all On my access DB i have noticed that the "on order" values for one of my number data types is providing negative values, even the number itself isnt correct if i were to simply take the - sign away. Attached is a screenshot of where the issue is presenting itself. If anyone has any...

Hello all, I am new to Access and VBA, know only the bare basics of access like how to create Tables, Queries, Forms and Reports, and how to sift through the data in each to a basic level, and some little things in VBA like the expressions such as =, <>, <, >, >=, <=. I have been hired by a...

Hi all, I currently don't know how select a field which has nothing in it using an if. The pseudo code looks like this: If [Employee] = nothing then [employee] =23 I don't know what to put in the code to use nothing as a criteria I've tried searching this up but only ended up confusing myself...

Hi all I'm looking for some examples or resources on the operations/theory of inventory systems, ideally it would be in relation to access. Any help will be greatly appreciated. Regards Hek

Hi all, I've tried to use conditional formatting as a way to make the selected row easier to see as a form of highlighting, but the closest i can get is having all of the rows be formatted. what I'm trying to achieve is when a row is selected, it formats the background. How I've gone about...

Hi all, I was hoping to get some insight on my current situation. The current database which i have created will require multiple users to be working on it at once. I believe that the best way to share this would be to put it on the local server for everyone to access, but i believe that this...

Hi all, What im trying to do is sum all the results of multiple DateDiff's to find a total. The only result i can get is all the datediff results all together one after the other in the same field (not added),I'm getting this result by adding the fields together in a query. Any help would be...

Hi all, I'm a bit lost with this. What I'm trying to achieve is that when I click a button it requery's the current form Im on and also another form in the database, which is also open. This is because a SetValue macro is also activate on the same button, so what i want to happen is that value...

Hello all, Currently a bit lost and any help would be greatly appreciated. Background:The company i work for makes and sells kits which contain lots of individual parts. What I'm trying to achieve is an inventory system which records the number of kits sold and all of the individuals parts...