Search results

I used to have a code to close the database itself after certain time. That worked well. But there were instances that this did not happen due to user closing the laptop or db being hung. Then I resorted to using an excellent code by MS which allowed me to shut the database completely. But I...

I have a MDE file which constantly keeps inflating in size. I did not notice this before as I used to republish this with a new copy. But over a period of 3-4 days, the size increases from 16 mb to 30 mb. Is this normal or should I take some steps to prevent this occurrence.

I have 4 fields which have certain dates in it. Each date (regardless of what date it is) signifies the rate of progress. So I have following rate: Survey ordered: 60% Layout Ordered: 30% Signage ordered: 5% Refrigeration ordered: 5% I would like to sum the percentages depending on the dates...

I am using a query to feed to report. In this query, I am using following field to provide category statement to serve as report groups. It works fine but I cannot seem to get rid of null records. When I try to exclude null records, I get a parameter prompt for 'survey due'. All other...

I have a database which has an on load event on a form capturing user log in id in a table. Lately, this tables keeps giving me an error as the auto numbering keeps reverting to an existing number. As this is not part of any relationship, it was a relatively easier for me to recreate a brand...

I am using following function to return percentage spend by testing against number of months elapsed. I am unable to show the CSpend as percentages and I cannot seem to get the percentages in the query. Will appreciate some help. Public Function CSpend(mMonths) If (mMonths) = -4 Then...

Error only on MDE I have a MDB file and it works fine. Debugged it. No issues. but when I create a mde, I get the attached error (The expression on load you entered....) Not too sure how to get rid of this. It is quite intermittent as sometimes I don't get it. It appears right at the start.

I am using the following by Allen Browne to sort one field. But now I need to sort on two fields. I wonder if someone could help revise the code. Function SortForm(frm As Form, ByVal sOrderBy As String) As Boolean On Error GoTo Err_SortForm 'Provided by Allen Browne 'Purpose: Set a form's...

I have password protected the back end of my split database. Works well when I re linked the front end. However, I am unable to change the links UNC using code. Do I have to live with hard directory refs or is there a tweak I need to make to the UNC code I am using. Curently when I use the...

I have a split database. I have secured the mde sufficiently but I need to secure the back end so that no one could link to tables in it. If I introduce a password to the back end is this going to require those using front end to supply the password? If not then this could be good solution...

I am calculating number of weeks between start and finish date. Some of the users have questioned the validity of calculation as they are not too sure if this is being calculated as Monday to Friday week or does it work by calculating 7 days. If the latter is true, then I should see a decimal...

I have a 2003 database front end that I publish in 2007 as well. I always have had a small utility in my DB that helped me to automatically close the front end after certain period of inactivity (for maintenance) and it worked well. For some reason this is not working in the Access 2007 mde...

I have a safety incident form where we record an incident against a project, sometimes this incident may involve a person and when this happens we record injuries in a sub form. So have one to many relationship between projects to incidents, and incidents to persons and persons to injuries...

I have a complex question. Will try to explain it. I have a query where I have listed stores and various projects that have been completed in that store as well as the date of completion. As part of the projects few things (SOW) were done to the store in its life time. So it is quite possible...

I am sure I am not asking a question that has not been asked before. I have a form and i can capture who edited the form using log in ID. But now the issue that is coming my way is that certain date field are more critical and we need to know who amended those dates and whether it is possible...

I have attached a sample spreadsheet. Each store has a planned date which is calculated off the dates in column b and c. The second row is actual date. As much of the data I have is in MS Access, I tried to use some extracts to appear in this format but no luck. I am hoping may be I can...

I used to use following code quite successfully but now using it after a long time, I noticed that code simply keeps running between While Not rst.EOF and Wend lines. This lifts the email address from a table where I have users listed and true false in front of their names. So it is designed...

With the dreaded roll out to chrome books, our business is now using Citrix to rum the application I wrote in Ms Access 2003 but published in 2007. Since the roll out, users are unable to analyse reports in Excel or PDF it or snapshot it. i am sure I am not the first person to have this issue...

I am using following routine to lift data from Excel files into Access tables. Whole thing works, well, most of the time. The only issue I have is the spreadsheets are received from warehouses and even though they have been given strict instruction to stick to the template, I have had to...

I am using the following formula to list quarters. Qtr: Format$(DateAdd("q",2,[Finish]),"\Qq yyyy",0,0) This really works on the premise of month end. However, as we follow an accounting quarter (using July-Jun financial year) which always starts from a Monday and ends on Sunday, I need to...