Desktop Time And Billing Template With VAT
Nov 12, 2013
I have a very simple database using the MS template 'desktop time and billing' for MS Access 2007.
[URL] .....
Any new template with the option for VAT or Sales Tax for each Billable Hour and each Billable Expense?
If this is selected or overwritten at time /expense input stage and then automatically added to the invoice.
Not sure why MS omitted Sales Tax from their design?!
Can Access Master add Sales Tax /VAT and then post as a new template?
View Replies
ADVERTISEMENT
Jan 26, 2014
I am using the Desktop services template as a starting point for an invoicing app. I would like to be able to add a product and/or service after the invoice is submitted so I can add a finance charge for invoices that haven't been paid yet. The template is setup to prevent items from being added once it is submitted. Looking for macro / rule that is preventing this action?
View 9 Replies
View Related
Nov 13, 2013
How would I go about doing this?
View 6 Replies
View Related
Jan 14, 2007
I've now decide to release this project as it now does All I want and thanks to all those from hear who helped with some of the solutions to my problems I'm happy with it.There are some items that have been disabled this is only because I don't need them at the min but when added I'll update the file, The tables are as complete as can be although there will be addition for later versionsThis version is for 2003 should you require 2002 please post a request for it.There will be additional tables as this project develops plus as I don't really use a lot of reports I've only added what I need but if you have a suggestion for a report let me know I will be adding a few as things develop.Thanks to Kent Telephones (http://www.k8t.co.uk) for hosting this project.IMPORTANT READ THE GETTING STARTED FOR SETTING UP AND INSTALLING THE SMTP DLL WHICH IS REQUIRED FOR THIS PROJECT TO RUN.Enjoyhttp://www.databasedreams.co.uk/freeware.html
View 14 Replies
View Related
Aug 2, 2014
What I am trying to do, is create a time billing form to track time spent on different tasks, with the following items in a neat form, in this format:
1) Client
2) Employee
3) Rate/hour
4) Date
5) StartTime
6) EndTime
7) BillableHours (*)
I am able to make a form that correctly works lets the user enter records for 1-6, with the user pressing crtl+shft+; to give the correct starttime, and then at the end of the task, the user can press the same and register the end of the task.
My problem is that I can't work out how to calculate 7) as one needs to input some VBA code that converts date/time to numeric values, allowing you to calculate time difference. However, I simply don't know; a) the proper 'code' that will calculate the time different between 5) and 6). I saw that it was perhaps the dateDiff command? And b) where I would even put that code into, i.e. the exact location where one goes to and types the code into... Is it a query? Do you set it to a Calculated value in the table editor?
View 7 Replies
View Related
Aug 28, 2006
Hello all,
I am talking to a potential customer about doing some contract work using access. This would be my first contract using access and I was just curious what some of you are charging as your rate. I'm a strong developer but my experience has been in a full-time position so I'm not sure what contractors would get paid.
Any help would be appreciated!
View 6 Replies
View Related
Apr 24, 2014
I have a form asking for a billing address and a service address. Many times these will be the same. I added a check box to check to populate the following fields; Service Address, Service City, Service State, Service Zip.
Fields that it will be coming from are the same, just named Billing instead of service. Tried expression builder and macro builder with no luck.
View 2 Replies
View Related
Feb 16, 2008
I have created a table for customer bills, and a table for customer profiles which contains rates associated with them specifically. The problem is that after a new rate change has been imposed I want to be able to look at an old bill, via a report, and have it reflect the "old" rate within proper historical context. I'm looking for suggestions on how to best manage ongoing rate changes while maintaining a billing rate history in my reports?
View 6 Replies
View Related
Oct 6, 2005
I am woking on a project full of nightmares. My latest, and the one I am currently unable to solve, involves trying to calculate the number of days between Billing Dates.
I have a table named "Date" - I didn't design this!
It contains a field named "Date"
If I query for just that Field I get the following:
Date
9/8/2005
8/8/2005
7/8/2005
6/8/2005
5/9/2005
...
I need to figure out a way to determine the number of days between the bills so I can calculate the average cost per day.
It seems like it should be an easy thing using like the datediff function or something, but since they are in separate records (rows), I can't figure it out. I have tried and tried and tried.
Any suggestions would be VERY much appreciated.
View 3 Replies
View Related
Nov 19, 2013
I developed a finance tracker database for tracking project revenues and costs (forecast and actual amounts). I have a form where we enter a new Work Order in the DB. This Work Order form has a continous subform where we create all the billing periods needed for the life of the Work Order. Once the billing periods are created (opened) we can then add our revenue and cost forecasts for each period. We have a Billing Period lookup table that has our billing periods with their respective start and end dates (which usually begin around the last week of a month and end about 3 weeks into the next month).
For the purpose of this question, lets say we only enter the required WO_Number and WBS_Code (Composite key) and the Work Order Start_Date and End_Date. I want to click a button to runs some code to automatically create all the billing periods for which their start and end dates fall into the Work Order start and end dates.
For example, say a Work Order starts on 5/1/2013 and ends on 7/31/2013
The billing period dates in the Billing Periods lookup table are as follows:
May-13 ---> 4/22/2013 - 5/19/2013
Jun-13 ---> 5/20/2013 - 6/23/2013
Jul-13 ---> 6/24/2013 - 7/21/2013
Aug-13 ---> 7/22/2013 - 8/18/2013
Then we would need the following billing periods created in the Work Order subform:
May-13
Jun-13
Jul-13
Aug-13
I don't even know where to start on this. Is it possible to automate this process with the setup I have? If so, how would I structure the VBA code/logic to use the billing period lookup table and create entries in the subform for all the billing periods that fall into the duration of the Work Order.
The attached DB is a stripped down version with only the tables and forms needed for this problem.
View 2 Replies
View Related
Jul 11, 2006
I hope this is the right forum for such a question, if not I apologize in advance.
I have an application that is being used by six people. When the newest version of it was built, I altered the desktop shortcut on everyone's PC to point to the newest version. Four of these shortcuts still work, but two are behaving somewhat erratically.
In the case of these two, clicking on the shortcut sometimes opens the older version of the application. I have recreated the shortcuts and they work for a while, before reverting to the older link. Going to the application via Explorer works fine.
While I am getting more comfortable with VBA, this area is outside anything I know. Could someone advise me on what affects whether shortcuts work or not? Do they automatically 'refresh'? If so, when?
In case it's relevant, everyone here is using the same versions of both XP and Access and everyone has access to the same drives.
View 12 Replies
View Related
Apr 12, 2005
:rolleyes: I know there is a way of placing a form on a desktop to an icon which only allows the user access to the form only! Help pleeease
View 1 Replies
View Related
Dec 6, 2005
Hello,I need to know is there any way to protect a shortcut on desktop ?Bcz someone is deleting (I dont know by mistake or intentionally) shortcut of database shortcut. I thinking about its protection from deletion only unless you have to supply a password or code something like that.Any idea..?With kind regards,Ashfaque
View 1 Replies
View Related
Jan 21, 2007
Hi all,
Today some of my users (primarily Access 9 users from what I can tell) have started experiencing weird Crash to Desktop issues.
The issue occurs when the user clicks a command button, which in turn should open an unbound form.
All other database functionality is working correctly.
The form is unbound, contains a combo, command button, listbox based on a query and several textboxes.
On open code is -
Private Sub Form_Load()
Me.cboType.Value = "Mail"
Me.lstResults.RowSource = "SELECT qryViewMail.ID, qryViewMail.Date_Received, qryViewMail.Customer_Name, qryViewMail.MDL_MVL, qryViewMail.Category, qryViewMail.Type FROM qryViewMail ORDER BY [ID];"
Me.lblStatus.Visible = False
End Sub
This functionality has worked correctly up until now.
Has anyone experienced similar issues before?
Thanks,
Rob
View 4 Replies
View Related
Mar 28, 2013
My server provider is telling me that my server is Linux and I would have to upgrade to windows to be able to connect my database to the SQL.so i figured, if there was a middle man who could collect the information and pass it along?Is there an add on of sorts to allow access to behave this way?
View 8 Replies
View Related
Aug 4, 2015
In my frontend code, I include a table with a version #. In my backend, I also include a version table. The front end will compare wih back end, and if it's different, it will force to get the updated version that it's stored in the LAN.
However, I do not want the user to open the file directly from the LAN because it might cause slow performance problem if multi-user,etc.
So I want to implement a code to force the application to be open only from desktop.
So far, I have a strUsername which detect the user network environ. Then, it will check the application path to determine if it was opened from:
C:Users<strUsername>Desktop
If not, then an error message will prompt to alert the member to copy the file in the LAN and save on their desktop.
It works on my laptop, all fine. Today I didnthe test in my user desktop, but the message saying that the file has to be opened from desktop keep appearing.
I double check the user folder and the Username environ is (cd98) but the user folder was setup as "CD98" capital letter. Does that affect the coding?
How can I make my code to not distinguish between lower or upper case either for username and folder user as well?
View 4 Replies
View Related
Feb 7, 2014
I used to have a code that we used to copy data from a folder that was on the desktop using the code below.
Code:
DoCmd.CopyObject "C:Documents and SettingsAll UsersDesktopWetcleans
This does not work with windows7. I have tried the C:USERSPUBLICDESSKTOPWetcleans but that does not seem to work either. How to access a folder on the desktop ?
View 2 Replies
View Related
Nov 15, 2011
I'd like to have a custom icon for the accdb file for the users. I recall doing it for pre-2007 databases, but I can't figure out how to change the 2007 db. Is it possible with 2007?
View 7 Replies
View Related
Dec 17, 2007
I built a database application, and I need for more than just myself to use it at the same time. I have just learned that I should have built a project instead. Can I change my application "Maintenance.mdb" to a project or do I have to start over?
View 5 Replies
View Related
Feb 24, 2014
I want to zip my file of my Desktop with MS Access 2007.
View 5 Replies
View Related
Mar 7, 2015
I was trying from a button on my form that will go to and bring up the desktop. I want it so I can put this database on anyone's computer and the button will work.
I am using this and it works but only on my computer.
Application.FollowHyperlink "C:UsersBryanDesktop"
I also tried this
Application.FollowHyperlink "C:Show Desktop.scf"
And
Application.FollowHyperlink "C:WINDOWSSystemShow Desktop.scf"
Both gives Runtime error 490 cannot open specified file.
View 14 Replies
View Related
Oct 21, 2013
How can I convert a web Access file to desktop aplication? I've created it from a model from Office.com, but I need create code in vba and it don't permit.
The use of file is only in desktop.
View 3 Replies
View Related
Dec 5, 2014
I have converted desktop Access database to SQL server. A medium sized app with 24 tables, 60 or so forms/subforms and about 120 queries. I created 2 split files, one containing the tables, and the other containing forms, queries, vba modules. I migrated the tables to SQL server using SSMA, and built an odbc connection for my front end. It works, except it is painfully slow. Its cos most of the recordsets that drive my front end are query based. And in many instances the queries are comprised of queries, not just tables.
Should i be creating my queries on the SQL server? Is that what people do when using Access front end with SQL server back end? Do away with Access queries? Or does the problem lie elsewhere? How do i network optimise my Access FE / SQL server BE?
View 10 Replies
View Related
Oct 31, 2014
I made nice little icons for my buttons, But when i transferred the app from laptop to server and run it on desktop comp icons get resized.
Guess it has to do with desktop resolution. How can i avoid this?
I tried with adding commands to playin pictures, but there are problems with focus, so that is not the best solution.
View 2 Replies
View Related
Apr 3, 2015
I have a split db that has been in use for a few years by about 12 people. The front end is compiled into an accde file.
Ocasionally a user (randomly) might get an error message "Microsoft has detected that this database is in an inconsistent state...." when closing the db and when that happens, a copy of the front end is automatically placed on their desktop.
This front end is always deleted and the original front end continues to work just fine afterwards.
Why are my users getting this error message? Why is the front end automatically copied onto their desktops?
View 6 Replies
View Related
Feb 5, 2014
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?
View 1 Replies
View Related
