Search results

Hi, i have 2tables,table1 id,name, table2 id,name,date. How can i write a delete query that will delete everything in table2,if the data date is today? Please i need sql statement or vba code thanks

Hi, I have a small inventory solution i did for a client. But the bottle neck here now is that the client wants me to include a ledger into the application, which i do not know how to start that. Can some one be of help here. I am not an accountant and so do not know what will make a ledger...

Hi, thank you very much for the response. It worked perfectly. Thanks

Hi, does anyone has a detailed login sample which displays the app current user and user privilleges in access 2010 sample vba code?

Hi, I have 2 controls, a textbox and combo box. I want to prevent users from entering anything other than number integers on the textbox and only strings on the combo box. I want codes that will prevent users by customized msgbox instead of default access error message. I am using ms Access...

Hi, I am just being curious if Access 2010 can in anyway be compiled to work in any operating system other microsoft environment? Does Open office support mac and can it be merge with Ms Access 2010? Thank you for your response Moore71

Hi, I need codes to browse pictures from desktop or folder and insert into access DB. I am using Access 2010. I also want the code to only insert the name of the picture and then link its folder through the ID or some text,ok? Thank you for this respose Regards, Moore71

Hi, Does any one knows the code to automatically backup backend to any folder or media in Access 2010? I need codes to be backing up my Back-End automatically. I am using Access 2010 format. Thanks in Advance Moore71

Hi, I want code to synchronize 2 or more databases. The databases are the same, but in different media,like in mobile flash drive,backup drive and main system Thank you Moore71

Hi, I have 2 or more identical tables in Access 2010.I need to synchronized both table at intervals automatically using code. Please how can this be done? Thank you for response Moore71

Hi guys,i need to know the best way to append,table1=productid,ProductName,Qty to table2=Productid,productName,Qty,date daily I want to be able to append Records daily from table1 into table2 OnClose.But i do not want duplication of record in the same day. If changes occurs in table1 after...

Hi guys,i have 2tables,table1=productid,ProductName,Qty table2=Productid,productName,Qty,date(). I want to be able to backup Records programatically daily from table1 into table2 OnClose.But i do not want duplication of record in the same day. If changes occurs in table1 after backup,table2...

Thank you Wayne for the response.I am quiet satisfied with your reply. My next question is if i backup,can it be done daily?What if there's change in data after backup,because the essence of table2 is to keep daily history of stock inventory automatically without duplication Thanks anyway

Hi guys,i have 2tables,table1=productid,ProductName,Qty & table2=Productid,productName,Qty,currentDate. I want to be able to append data programatically once daily OnClose.Although users can log-off & on as many times,but the Append should be once & after then,update subsequent records for that...

Thanks for the response.This is an eye opener to me that nothing is impossible with good thinking Thanks alot

Hi guys,i have an inventory app,i want an idea on how to make daily opening stock /closing stock.I want the system done automatically,that is as users exit,closing stocks & next day opening stocks as users log in.Then daily stock reports can be generated. Thanks in advance anyway

Hi, I have a mini sales app that when i select item bar-code number base on the ItemID,every record for the item displays on a continuous form. Now i want a way i can select by either Item name or the bar-code still on the continuous form using combo or any other control. I know its possible in...

Hi fellow members, I am new to this forum. I am also an average ms Access programmer, i hope i can get some of my issues solved through this media. Thank you, John Moore