Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 69
Search took 0.01 seconds.
Search: Posts Made By: Hek
Forum: Modules & VBA 09-24-2019, 07:16 PM
Replies: 3
Views: 94
Posted By Hek
Re: DLookupStringWrapper

Cheers man, just as you answered i figured it out xD

Cheers heaps for the help man, i really appreciate it.

Regards,
Rhys.
Forum: Modules & VBA 09-24-2019, 07:07 PM
Replies: 3
Views: 94
Posted By Hek
DLookupStringWrapper

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...
Forum: Theory and practice of database design 09-18-2019, 03:00 PM
Replies: 6
Views: 240
Posted By Hek
Re: Junction table inventory

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.
Forum: Theory and practice of database design 09-16-2019, 10:58 PM
Replies: 6
Views: 240
Posted By Hek
Re: Junction table inventory

It is, but what would that change/help with?
Forum: Theory and practice of database design 09-16-2019, 10:11 PM
Replies: 6
Views: 240
Posted By Hek
Junction table inventory

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...
Forum: Modules & VBA 08-27-2019, 03:55 PM
Replies: 6
Views: 146
Posted By Hek
Re: Check box issue

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...
Forum: Modules & VBA 08-27-2019, 03:16 PM
Replies: 6
Views: 146
Posted By Hek
Re: Check box issue

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...
Forum: Modules & VBA 08-27-2019, 03:01 PM
Replies: 6
Views: 146
Posted By Hek
Check box issue

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.
Forum: Modules & VBA 08-27-2019, 02:49 PM
Replies: 14
Views: 200
Posted By Hek
Re: Number data type showing negative (-) numbers

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...
Forum: Modules & VBA 08-26-2019, 05:21 PM
Replies: 14
Views: 200
Posted By Hek
Re: Number data type showing negative (-) numbers

how would i make a backup DB and wipe all the confidential info off to post here?
Forum: Modules & VBA 08-26-2019, 04:27 PM
Replies: 14
Views: 200
Posted By Hek
Re: Number data type showing negative (-) numbers

Hey there

it is a number data type, not calculated.
Not sure why this is happening, any thoughts?
Forum: Modules & VBA 08-26-2019, 04:11 PM
Replies: 14
Views: 200
Posted By Hek
Number data type showing negative (-) numbers

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 -...
Forum: Modules & VBA 08-21-2019, 09:30 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

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...
Forum: Modules & VBA 08-21-2019, 06:52 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

People understand how it SHOULD work, but dont know why it isnt running how it should due to lack of IT skills.
Forum: Modules & VBA 08-21-2019, 06:14 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

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

Regards, Rhys.
Forum: Modules & VBA 08-21-2019, 05:58 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

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...
Forum: Modules & VBA 08-21-2019, 05:41 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

So ive been able to find the (kits) table in which the "on Order" values are stored, they are showing the incorrect values (exactly the same as the "inventory Modification" form.) When i open the...
Forum: Modules & VBA 08-21-2019, 04:35 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

Made a backup and opened the table in design view. here is a screen cap :)
Forum: Modules & VBA 08-21-2019, 04:13 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

I have found the Kits table with all the same incorrect values displayed, have any ideas on what i could do next?

Thankyou so much for your time and effort, you are truly helping me.

Regards,...
Forum: Modules & VBA 08-21-2019, 04:07 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

attached is two PNG, first one is the general data, and the second one shows how many different recordsource options there are.

Regards, Rhys.
Forum: Modules & VBA 08-21-2019, 03:59 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

Clicked that black square, and it brought this up.

Regards, Rhys.
Forum: Modules & VBA 08-21-2019, 03:49 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

Here is a pic of where i am at now :) (company name scribbled out for their sake xD)

Regards, Rhys

EDIT: that "on order" column is the one showing the wrong values. :)
Forum: Modules & VBA 08-21-2019, 03:28 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

Thankyou man, i cannot find the table that corresponds to the inventory modification form. Any ideas?

Thanks heaps for helping, it is truly appreciated.
Forum: Modules & VBA 08-21-2019, 03:21 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

How do i show properties on a form??

Regards, Rhys.
Forum: Modules & VBA 08-21-2019, 03:20 PM
Replies: 69
Views: 854
Posted By Hek
Re: New to VBA and Access, Need General Help :)

Form :)

Thanks for helping

Regards, Rhys.
Showing results 1 to 25 of 69

 
Forum Jump



All times are GMT -8. The time now is 09:15 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World