Search results

All orders will be the same so the tasks will be too. The tasks will be associated with the order and certain employees will do certain tasks.

Thanks for the input everyone, the reason I want to do it this way is because all the records in tasks are the same for every new order that comes in and there are 28 individual tasks that need to be marked as completed, so I was trying to use VBA to add all the tasks in the tasks table to the...

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

Cheers man, just as you answered i figured it out xD Cheers heaps for the help man, i really appreciate it. Regards, Rhys.

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

Thanks The_Doc_Man and Pat Hartman, that's what i was looking for. It gives me a good starting point for tackling my problem. Thanks again.

It is, but what would that change/help with?

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

The DB was built by the previous employee so im unaware of some things, but the form is in continuous mode yes. I don't have a "shipped" table yet, but im hoping to get the data to go from this "orders menu" form and be transferred to a "shipped orders" form or table. EDIT: The reason for this...

Im very new to access and VBA so pardon my lack of knowledge. Im looking to click a checkbox, and once that checkbox is clicked, i want that line of data to be transferred over to another table called "shipped orders" and for that data to be deleted from the original table, and only stored in...

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.

Private Sub Command34_Click() If [Quantity] <= [Stock] Then Me.Stock = Me.Stock - Me.Quantity Me.Picking_ID = 4 Me.Fabrication_ID = 4 Me.Finishing_ID = 4 Me.Pressure_Testing_ID = 4 Me.Packing_ID = 0 Me.On_Order = Me.On_Order + Me.Quantity Me.Status_ID = 0 Me.InventoryID = 2 'Inventory is good on...

how would i make a backup DB and wipe all the confidential info off to post here?

Hey there it is a number data type, not calculated. Not sure why this is happening, any thoughts?

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

Have corresponded with the previous owner of the program, he has tried to help VIA phone but we couldn't get much done due to not looking at the same program on both ends, he should be coming in sometime early next week to troubleshoot with me. I will update here with the outcome of the...

People understand how it SHOULD work, but dont know why it isnt running how it should due to lack of IT skills.

this is a display of the incorrect values in their respected columns if this helps anyone. Regards, Rhys.

The person who worked here previously should be in contact with me to try and help me overcome some of these issues, i have some worries that he didnt fix the issues simply because he didn't know how, but i will ask him the questions ive been asking on here and see where it gets me. He was the...