Search results

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...

It worked Neutron, Thank you very Much. Thanks again

Wow, I had not thought of that, I will do that now, I am really grateful. I am sure that will work. Thanks, but I will make u know just incase I find any anomally. Thanks a bunch Neutron

I do not know if I can ask this here, but assuming I have this code: Docmd.openform(name of form) I would like to click a button that will comment this code so that the system will not execute it, ie change it to 'Docmd.openform(name of form) Is there an easier way to do this, eg by using goto?

Thanks to all of you jdraw, Brian, and Neutron, My code finally worked . The final code was this line: strSQL = "UPDATE InstDetails SET InstDetails.InstallationDate = Date() WHERE (((InstDetails.InstallationDate)=#3/12/1990#));" Debug.Print strSQL CurrentDb.Execute strSQL, dbFailOnError...

I changed the code to: strSQL = "UPDATE [instdetails] SET [installationdate] = " & Date but it gives the same result

Hi Brian, I want the system to set the date in that value to the current date, if the date in that field is the default ie if it is 03/12/1990, it should set it to the current date. What is the syntax of the current date?

Hi BrianWarnock. I had thought of an update query but I am not so good with queries. I do not know what to add to the : 'Update to:' and also what to add to the : 'Criteria'.

Hi Neutron, I used your code and I am happy my table got editted but there is a funny anomally. Here is the code I used: Private Sub Form_Load() Dim dateinstalled As Date dateinstalled = DLookup("installationdate", "instdetails") If dateinstalled = DateValue("March 12, 1990") Then...

Thank you very much Neutron, Let me try out your code, although I will not add the criteria part, because my table has one record of the institution details...

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...

Dear Clair, I am not really sure that I got your question right, but I am getting that following that the ID field is an autonumber, you want to rearrange the numbering without overiding the database. If this is what you mean, do this: Go to the desired report and switch to design view, change...

I have used it in 2007, it works there too.

I was able to make it work using the following code: Dim rowcount As Long Set lst = Me! [List68] For rowcount = 0 To lst.ListCount - 1 lst.Selected(rowcount) = True Next

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]...