Search results

I have a form whose fields are specified by the user. Sometimes, they need to add a new column. I am able to do this in vba using alter table so that is not the problem. The problem is making this column appear on the form without going to design view. Is it possible for the system to auto show...

Hello all, I am looking for Access VBA code to display a form on an external monitor. Kindly assist me

I have a Church Database and the current version has a lot of data in subfolders that one cannot get rid of even in a new installation. When packaging the solution, access doesn't allow me to carry photos, slides etc that are in sub-folders. For example, I have .ppt slides of songs that are...

I have a church database and I need to send data to the projector. I have been projecting from access through PowerPoint VBA and its been working well, but it doesn't do enough. I was wondering if I can project directly from access without having to go through PowerPoint. in other words I'm...

I have a website and I want to be able to synchronize data from my access 2007 db. I have looked at many forums that talk about asp, others talk about dataAccessPages, but I dont know the best way to approach this. First, I need to know the best method to approach, and two, I need to know how...

I have an access 07 system, packaged with Access 07 Runtime. A new customer needs the system but he has a laptop with Windows 8 and with office 2010 installed. Is there anything that I should change before I make the installation? Can a system packaged with Access 07 Runtime work well in Office...

I have an access 07 application but one of my clients bought a laptop with Windows 8 and Office 2010 installed. What should I do or change prior to the installation? Regards

A church asked me to integrate my ms access church management software with fingerprint recognition. The finger scanner is to be placed at the entrance and members will pass via it. After a scan, the details should be matched and updated into the system that the member is present. I do not know...

What code should I use for the system to carry out a certain action every time it is a certain date of every month. eg if the date is 5th, the system should invoice all tenants with rent of the value of the house they live in. I am unable to work with the date changes. Every time we get to a...

I am making a rent system, that has to track time so that every month it will set rent values to all tenants. I am unable to make the system recognize a month change. ie if I tell the system, if currentmth = currentmth+1 do the following...... it will not work because time changes...

I have a simple database that is supposed to manage tenants, houses and rent payment. I input House details with fields as HouseID, HouseName, and ifOccupied(yes/no) fields. THere is then another table that stores tenants details as they come in to rent the houses. The house field in the tenants...

I have a 2007 access database that has been working until not long ago when one of the forms gives the following error: the expression on click you entered as the event property setting produced the following error: User defined type not defined. This error comes up on every action of the form...

Hi all, it was my first time today to split my database. It is a church software so it is to be packaged and distributed. It is an ms access 2007 db and I usually package using the usual ms access package wizard. When adding into the additional files, I usually include the accdb file but encrypt...

Hi all, I would like to add code in my database that will edit a table. The table has a field that stores a date value. Everytime the program is run, it is to check if the date is the default date, and if it is, it is to change that date stored in that table, to the current date. ie, if date...

Hi, in my Access Database, I have welcome sounds that play when one opens the database. However, I would like to add a button that one can click so as to mute all sounds if they wish to. The code that plays the sound is as follows: Dim iRetValue As Long iRetValue =...

Hi there, I need to clarify a few things concerning access 2010. I developed a system using access 2007 and it is working alright. However, I recently upgraded to office 2010 and i was thus trying to use my system in it. However, following that I need to package the software for new users, do i...

I am creating a system where I need to track dormant members. It is a church system. I need to track all members who have not tithed for a whole month, all those who have not been involved in any transaction, all those who have had no activity, all those who have not attended a certain...

My database takes around 3 minutes to compress and repair. It will make a slow computer to hang for that period. I thought that period is too long. Again there is this form that whenever I try to open it, it gives this error: "the expression on Load you entered as the event property produced...

I have an Access 2007 database that sends emails to any members selected. I however need to send messages to phones of the members in the database, following that I come from a third world country where not so many people have email addresses. I know there is the outlook method of sending texts...

I am using Access 2007. I have a multi select list box that has all mail addresses from a query. The code I have sends mails to only members who are selected from the listbox. I want it to send to everyone. I need code that can select all items in a list box. I tried set lst=me![maillistbox]...