Search results

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 tblItems with the correct quantities. the relational data will be the barcode and is unique to each...

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 via the subform route so i will need some suggestions. what i have is a one to many table format...

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 for each employee. i have attached the relevant tables and a query that shows the information i need...

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 the timer set at 1000 so refresh is not a problem. heres the function i have to display the days...

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. the corresponding fields in each tbl are tblMultiSchedule.OrderItemID1...

i have tried to do this record set all on my own but i am struggling. i get an error that causes me to have to shut down access through task manager. luckily i have learnt to save it before i test it(experience) 'open record set' Dim rs As DAO.Recordset On Error GoTo Err_Proc 'Check To See If...

I have a report that shows the daily activities. it shows how long it takes to do each task. however some tasks are 8 hours andsome are 10 hours. when all these times are added together it will give the time on a clock. not a total of hours spent. ie. treatment1 : 8 hours treatment2: 10...

I am trying to create a button for me and other users to export reports to excel. using the ribbon the results are correct. using DoCmd.RunCommand AccmdExportExcel seem to give different results. as I say using the export to excel gives the correct export but using the vba gives incorrect...

i have just tried to amend my query. the idea is that the initial results are to show all items that are instock. ie have a value >0. if i click a check box i want to display all items that are available regardless of stock. so my criteria expression is as follows...

I have vba that runs at 08:30 am. I would now like to run vba on the 1st of each month. how do I do this. for the time I use If TimeValue(Me.txtClock) = TimeValue("08:30 AM") Then.......... thank you

i need a method to store an expiry date. i have a column prepared in my table but i do not know how to reach the desired result. the date will always be different depending on certain criteria the course length. some courses we have are valid for a month. some for 6 months. some for a year...

i have a report and at the footer i want to show how many of the txt boxes i have are >0 i tried =Count([txtbox]>0) i know that this is quite simple but i just cant get it thanks

sorry to have 2 threads so close together but i want to hit this from both angles. i have just thought. with the linking tables thing to outlook can it be reversed. ie if i have a table that was linked to outlook outbox would the records form an email just like the emails from my inbox form a...

i have just found out that i can call data from my outlook email files and place them in a table. i started by using the link table wizzard. i now need to know how to refresh the link automatically. i could do it on a timed or open event but i dont know the code to do it. can any one help with...

i a little frustrated and confused with this. i have a check box on my subform that when clicked enters an amount in the main form record. it changes automatically and when i do this i get a write conflict asking to save/cancel/drop. ive tried to save the record on this event but it doesnt...

i am trying to move all my tables over to my sql but i am having trouble with the functionality of my forms. in particular updating and creating new records. for instance i have a form that goes to new record on open, however the unique id field is empty. there isnt a new record being...

i have built an access database that we use day to day in our business. it is primarily an appointment book with reports and stats that go with it. now i want to take it to the next level. online booking. i am planning on exporting the access tables to mysql, this will be hosted on my pc not...

i have recently asked about being able to use my table system online. i have just thought. what about creating a front end that works online. still have the front end on the desktop and the table system on the desktop but have both of them connecting to the one table system. will this work?

i have nearly completed my database for an appointment system. now i want to take this online. i know that there is 2 ways of doing it. putting the tables in the cloud or having the cloud communicate with my database on the desktop. i have concerns with both ways. tables in the cloud. how long...

ive completed my automated text reminder system and today ive been thinking of sending direct messages through twitter and facebook. some of our client dont want to give us their mobile number to send txt to so i would like to be able to do it through twitter. has anybody got any idea of where...