Search results

Hi All, I have three access 2007 databases that used to work just fine till we upgraded from Office 2007 to Office 2013. Now on certain occasions when we hit some buttons (that have got some macro or VB procedure behind the buttons), the databases just closes itself. I have checked again by...

Hi Folks, I want to create a button called "Export To Excel". Then embed code behind this button, so that when ever it is clicked it open the displayed report in excel format. I want to then place this button on any report that I create in my database, and upon clicking that button I want the...

Folks, I have a Access 2007 database, which has a 45Mb backend that sits on a file server (windows SBS 2008). I have 15 users using windows XP which have their own front end. When a single user is on the network the average time to execute a query or report is under 1 second. However when...

I have an access front end, that has a field called Documents link, this field normally contains an entry for each client that points to a set of folders of a win 2008 file server. The hyperlink works fine, however when I open the Folders using hyperlink, the path to the folders in the...

Folks, I want to design a form that looks like the following (see attached) At intersection of each row and column I want to display the result of a query. at intersection of visas and 15 days I am displaying result of following query. SELECT Count(*) AS [No Of Visas Expiring in Next 15...

Hi Folks, I have a client table, in which I have an attribute called photo (datatype OLE object). Subsequently in the client form I have dragged this field and placed it on the form. I can right click on the box for photo and insert object (I store in this OLE object and link to client...

Folks, Is it possible to create a subform within another subform. Main form -- Client Subform Dependent Further subforms of dependents - Medicals, Police Clearance, Qualifications. My client form shows dependent data, but the subforms within dependents turn out to be either totally blanks...

Folks, I have a database with front of each user (about 15) and a backend that sits on Windows SBS 2008. The issue I am facing is that when one user inserts a new record in the database, the other users who already have the database open on their machines cannot view it. Either the others...

Folks, I have a standard access database with customer records. I have some PDF forms (to start with 3 forms). I wish to create a facility that once my users navigate to a particular customers record, they can then merge that particular record to one of the three PDF forms. I am not...

I have a multiuser database, it has a backend and then all users have heir own front end. However when a user is creating a new record in their machine, it does not show on other machines till the user who created the record restarts their front end and also the other users close their front...

Folks, I run a small access database in-house, the database has a front end for each client and backend is on windows server 2008. Attached screen shot. On the same server there is a folder called 1PR which houses folders for various clients. Each client folder then has various subfolders...

Hi Folks, I have the following query that generates a list of reminders that are due:- SELECT Reminders.Date, Reminders.Time, Reminders.Set_By, Reminders.Reminder, Reminders.Due, Reminders.Allocated, Student.SID, Student.FName, Student.LName FROM Student INNER JOIN Reminders ON Student.[SID]...

Folks, I have a database that is roughly 15MB in size and is shared by around 12 users simultaneously. The database sits in a windowss 2008 SBS file server. On one of the PC's the database is crashing very frequently, especially when a user tries to type a long note in the notes field (which...

I have a access DB, which has a backend that sits on a server, and each client has their own front end. Till now the backend was hosted on Win 2003 server in a workgroup mode. Recently we bought a quad core Xeon machine and installed SBS 2008 standard on it. we put the backend on this machine...

Colleagues, I have a client for, and attached to it is a subform called reminders (attached). I wish to create a button on this form, so that whenever users set a reminder then can press that button and the reminder data can be added to Ms Outlook calender. Fields that I wish to export are:-...

Hi, I have two fields in a payment table. 1st Field is "Method", the users can only shoose 1 of the four value i.e. Cash, EFTPOS, Direct Debit, Internet Transfer. 2nd Field is "Trans_No" (transaction number). I want to setup a validation rule so that if users select the value "EFTPOS" in...

I have a subform called payment, which is linked to parent form (client). When users select the value EFTPOS using the drop down box called method, I want that they must then fill a value in the box Trans_No. If they choose any other value using drop down box called method, then we can set...

Folks, I have a split access database, with about 15 users (each has own front end) and the backend is on a server. My users have the option within the database to setup reminders for them selves or other users. How can I do the following:- When the users setup a reminder, I wish to give...

SELECT Payment.Pay_ID, Client.Client_No, Nz(Fname)+" "+Nz(LName) AS [Client Name], Address, Payment.PDate, Payment.Purpose, Payment.Method, Payment.Notes, Payment.Amount, Received_By, Nz(Payment.Purpose)+" - "+Nz(Payment.Notes) AS [Report Field] FROM Payment, Client WHERE...

I have a split Access DB with about 12 users each having their own front end. Often we note that once a user enters data the other users cannot see it till they close their database and re-start it. It is a new problem, never use to happen earlier.