Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.04 seconds.
Search: Posts Made By: shutzy
Forum: Queries 08-15-2015, 12:16 AM
Replies: 3
Views: 689
Posted By shutzy
updating table with a count or sum

i am trying top create a stock take form. the form is now set up so each time an item is scanned a new record is created in the tblStockUpdate. i ow need to create an update query that updates...
Forum: Forms 06-17-2015, 09:29 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

i have managed to make it show the records with the after change event on txtSubID to requery the subform.
Forum: Forms 06-17-2015, 09:24 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

thank you for that. but what is it meant to do exactly. there are no records appearing in the -TreatmentSubform
Forum: Forms 06-17-2015, 06:57 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

have you not opened the attachment?

frmWaitingList-Subform Has ID and frmWaitingList-Treatmentsubform has tblWaitingListID.

sorry i wrote the last post incorrectly
Forum: Forms 06-17-2015, 06:45 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

tblWaitingList.ID & tblWaitingListTreatments.tblWaitingListID

the tblWaitingListID maybe should be WaitingListID
Forum: Forms 06-17-2015, 06:14 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

in the treatment subform master field i have put

Forms!frmWaitingList!frmWaitingList-Subform!ID
in the child field i have put
tblWaitingListID

is this right. is it even within the correct...
Forum: Forms 06-17-2015, 05:50 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

sorry im braindead. try checking design view. ha ha
Forum: Forms 06-17-2015, 05:35 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

i have read it and i dont seem to be able to find the subform linker. is it because i created a form then draged it in instead of creating a subform within the main form
Forum: Forms 06-17-2015, 05:30 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

what would this do. or is it a big suprise?
Forum: Forms 06-17-2015, 03:05 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

i have attempted what you suggested vba. i have created 2 subforms. both continuous. i have created a buttton on the waiting list record to show treatments within that record on the 2nd subform. just...
Forum: Forms 06-13-2015, 03:35 AM
Replies: 19
Views: 1,225
Posted By shutzy
Re: continuous from with subform

sounds like it would do the trick but im not sure the data would display easily.

its for a waiting list. so we could do with quick viewing and the girls are beauty therapists. not exactly pc...
Forum: General 06-13-2015, 03:25 AM
Replies: 18
Views: 1,104
Posted By shutzy
Re: Audit Trail Option in Access

i have an audit trail. im not sure if i did it correctly but i created an audit tbl. then on every click of every button i put some code in. to append data to the audit tbl. i did create a log in...
Forum: Forms 06-13-2015, 03:07 AM
Replies: 19
Views: 1,225
Posted By shutzy
continuous from with subform

i know all you guys out there are gonna tell me this cant be done for various reasons however i had this image in my head of what i wanted to do and what it would look like. however it cant be done...
Forum: General 02-12-2015, 05:55 AM
Replies: 7
Views: 692
Posted By shutzy
Re: First Appointment Of The Day For Each Employee

i wasnt trying to argue. i was just trying to find the most definitive route of getting the unique record. there are variables that can happen that would cause an error in this. because it is not a...
Forum: General 02-12-2015, 05:31 AM
Replies: 7
Views: 692
Posted By shutzy
Re: First Appointment Of The Day For Each Employee

the date and time are not unique to them. some days we have 4 employees and all could have something in at the same time. i really could do with OrderID to be able to have the unique relationship.
Forum: General 02-12-2015, 04:49 AM
Replies: 7
Views: 692
Posted By shutzy
Re: First Appointment Of The Day For Each Employee

that is what i acheived but you have the extra OrderId in there. when i added that columnit listed more than just the results you got. all i need now is to add the column
Items.

i have added the...
Forum: General 02-12-2015, 03:53 AM
Replies: 7
Views: 692
Posted By shutzy
First Appointment Of The Day For Each Employee

hi guys, its been a while since i was last on here but i have run into some difficulty with a query

i would like to append some data to a tmp tbl.

i want to get the first appointment of the day...
Forum: General 09-09-2014, 04:22 AM
Replies: 10
Views: 600
Posted By shutzy
Re: xmas countdown

i managed it.

text box 1 = =Format(#25/12/2014#-Now(),"0") (gives day count)
text box 2 = vba - Me.txtCountdownHoursMinutesSeconds = Format(#12/25/2014# - Now(), " hh:nn:ss")

bingo
Forum: General 09-09-2014, 03:52 AM
Replies: 10
Views: 600
Posted By shutzy
Re: xmas countdown

no worries i understand. i just thought it was smple enough for a quick answer
Forum: General 09-09-2014, 03:42 AM
Replies: 10
Views: 600
Posted By shutzy
Re: xmas countdown

thanks vba. i tried that but im not sure how to do it. i dont use dates much.

i did try

format(DateDiff("d",Now(),#25/12/2014#),"d hh:mm:ss")

but this didnt seem to work.

have i done...
Forum: General 09-09-2014, 03:40 AM
Replies: 10
Views: 600
Posted By shutzy
Re: xmas countdown

sorry. the database is that large now there is no way the limits would allow it. even when zipped.
Forum: General 09-09-2014, 03:27 AM
Replies: 10
Views: 600
Posted By shutzy
xmas countdown

i would like to have an xmas countdown. i currently have it displaying just the amount of days. i would prefer it if it had days hours:minutes:seconds.

i have already have it on a form that has...
Forum: Queries 07-02-2014, 07:39 AM
Replies: 4
Views: 995
Posted By shutzy
Re: update query from one table to another

ok ok. the reason they have been duplicated is for a diary system.

i have frmDiary and frmDiarySub1. sub1 holds 5 columns which each relate to one set of details in tblMultiSchedule.

i had...
Forum: Queries 07-02-2014, 06:26 AM
Replies: 4
Views: 995
Posted By shutzy
update query from one table to another

i have 2 tables that hold similar data. in one table tblMultiSchedule i have a few blank columns. i want to update each column(ActualCost*) with the correct data which is stored in tblOrdersItems....
Forum: General 06-19-2014, 05:06 AM
Replies: 5
Views: 680
Posted By shutzy
Re: record set. too few parameters set

one more thing to get the cogs ticking. the record set seems to exit sub
Exit_Proc:
rs.Close
Set rs = Nothing
Exit Sub
i have some more vba that i want to continue after this. how...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 10:08 PM.


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