Go Back   Access World Forums > Search Forums

 
Showing results 1 to 18 of 18
Search took 0.00 seconds.
Search: Posts Made By: monk_1987
Forum: Modules & VBA 01-30-2018, 08:34 AM
Replies: 9
Views: 1,113
Posted By monk_1987
Re: Open a record on subform (in a main form) from listbox

Hmmm.... I am confused here. I understand what you are saying, but will the correct business record open if I am only telling it the 'IDToDo' field as appose the 'IDBusiness'.

Can I have an idiots...
Forum: Modules & VBA 01-30-2018, 06:23 AM
Replies: 9
Views: 1,113
Posted By monk_1987
Re: Open a record on subform (in a main form) from listbox

Here is the main menu form

69504

Here is the form and subform I want it to open

69505

Thanks again
Forum: Modules & VBA 01-30-2018, 05:57 AM
Replies: 9
Views: 1,113
Posted By monk_1987
Re: Open a record on subform (in a main form) from listbox

Can I do this? Because the subform is linked to the business form. Can I then link a list box to the same subform?
Forum: Modules & VBA 01-30-2018, 05:54 AM
Replies: 9
Views: 1,113
Posted By monk_1987
Re: Open a record on subform (in a main form) from listbox

Thanks

I've tried opening the form with "IDToDO =" but no luck. It works in terms of ID, but it opens the subform, but not the business form too...

What code do I need to use?
Forum: Modules & VBA 01-30-2018, 05:15 AM
Replies: 9
Views: 1,113
Posted By monk_1987
Open a record on subform (in a main form) from listbox

I am really stuck at the moment, I have searched here, google and tried many different things myself, but can't find an answer that works.....

So, I have a main menu with a to do list box.

I...
Forum: Queries 05-12-2015, 08:31 AM
Replies: 6
Views: 2,910
Posted By monk_1987
Re: Update query for stock levels

Right. I see what you're saying now. Apologies... Just one last question then to clarify. Put the stock level in a query and create a transaction table which can trace the orders?
Forum: Queries 05-12-2015, 08:10 AM
Replies: 6
Views: 2,910
Posted By monk_1987
Re: Update query for stock levels

Thanks for the reply. The query does do the calculation for me. It just get the data from the table to see how much is currently in stock. Then I want the query to update that stock count (in the...
Forum: Queries 05-12-2015, 07:58 AM
Replies: 6
Views: 2,910
Posted By monk_1987
Update query for stock levels

Hi guys

I've honestly been on this topic for a few days and can't figure it out :banghead: I have searched this forum and google for hours on end without finding an answer. So if someone could...
Forum: Modules & VBA 02-05-2015, 07:08 PM
Replies: 4
Views: 683
Posted By monk_1987
Re: equals to not working!

That has worked a treat!! Thanks so much. Just out of curiosity... What makes that work? Don't worry if you don't fancy explaining it :) I appreciate the help!
Forum: Modules & VBA 02-05-2015, 06:32 PM
Replies: 4
Views: 683
Posted By monk_1987
equals to not working!

Hi there everyone

I have a problem with some code that does not work and I am beginning to pull my hair out, so any help would be appreciated.

The problem is on the line If...
Forum: Modules & VBA 03-05-2013, 02:54 AM
Replies: 2
Views: 951
Posted By monk_1987
DLook up returning multiple records - Help

I have a continuous form which displays contacts (private pupils, as I run my own music tuition business) from the contact table. There is another table which links to the contact table which stores...
Forum: Forms 02-28-2013, 09:45 AM
Replies: 1
Views: 609
Posted By monk_1987
Calculate multiple records

If anyone can help it would be awesome!! Anyway...

I run my own music tuition business and I want to be able to do take an annual record attendance score for each customer/pupil, just so I can see...
Forum: Modules & VBA 11-01-2012, 07:22 AM
Replies: 0
Views: 667
Posted By monk_1987
DLookUp only selecting first two records! (moved from General)

Hi Guys

I have another problem and new this was the right place to come as people have sorted out some problems for me before!

So... I have a hidden form that pops up when the main menu is...
Forum: Modules & VBA 10-09-2012, 04:23 AM
Replies: 7
Views: 954
Posted By monk_1987
Re: Another question on else function! Please help

Thanks Pat. I will do that!

Guys thanks so much for your help. I can't believe how willing people are to help you on here. Should have joined sooner!
Forum: Modules & VBA 10-06-2012, 05:33 PM
Replies: 7
Views: 954
Posted By monk_1987
Re: Another question on else function! Please help

Thank you so much for that DrallocD. It works an absolute treat! That has been driving me nuts for ages!
Forum: Modules & VBA 10-06-2012, 03:00 PM
Replies: 7
Views: 954
Posted By monk_1987
Re: Another question on else function! Please help

Hi guys

Sorry about the lack of code before. Here is is below though!

On Error GoTo Err_Handler

If IsNull(NameofSchool) Or IsNull(SchoolType) Or IsNull(SchoolAddress) Or...
Forum: Modules & VBA 10-06-2012, 03:51 AM
Replies: 7
Views: 954
Posted By monk_1987
Another question on else function! Please help

Hi

I have a problem which has been bugging me for a while now, so thought I would sign up here to get it sorted! So here it goes.

I have a form with a close button on it. I have written a...
Forum: Introduce Yourself 10-05-2012, 07:06 AM
Replies: 1
Views: 433
Posted By monk_1987
Croeso (Welcome in Welsh)

Hello

Not a big fan of talking about myself but here it goes anyway!

I am from Wales and am a fluent Welsh speaker (Welsh being my main language). For those who have never heard of Wales...
Showing results 1 to 18 of 18

 
Forum Jump



All times are GMT -8. The time now is 03:10 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