General
in [Access]
|
Functions to = a total field I am having trouble getting a total field, This is how I am setting it up AmountRecieved - AmountSpent = TotalSpent, what am I doing wrong, or rather what do I need to do and what view do I do it in? ... 7 May 2010 14:32
Can I link a FE to a BE with a runtime version in 2007? when I run this command ( RunCommand acCmdImportAttachAccess ) in a runtime version- the wizard appears but is 'deformed' and does not work. However, in a accdb version of the same data base it all works perfectly- is this just a runtime (accdr) thing or is there a way around this with vb? What I am doing is a... 7 May 2010 14:32
Set Control source at runtime Access 2003 I'd like the user to be able to choose whether to sort a report by one of two criteria. I have a form with a dropdown box where they make the choice. Depending on the choice, I'd like to set the caption of the first column of the report to the choice and likewise set the control source of the fir... 10 May 2010 10:59
Access frontend with SQL Server backend: my solution for ODBCCall error hi Arvi, My solution: [..] Cool, nice piece of work. mfG --> stefan <-- ... 7 May 2010 08:56
messages comment me débarrasser de tous les messages que j'ai reçus? merci De: "WLMPilot" <WLMPilot(a)discussions.microsoft.com> Objet: How to adjust physical lengths of fields Date: mercredi 14 avril 2010 21:26 I am new to the 2007 version of Access. I have a table with three fields: ID#, Last Name, and First Name. ... 7 May 2010 12:16
Access frontend with SQL Server backend: my solution for ODBC Call error Hi This thread follows threads I started in forums microsoft.public.access.forms, and microsoft.sqlserver.programming: 1. 'Overriding constraint violation message' at 21.04.2010 12:00; 2. 'Overriding constraint restriction message, when deleting record(s) from form' at 29.04.2010 10:36. The problem (Occurs ... 7 May 2010 06:44
Wrap Text in Access Form Pivot table I need to display lots of records from a query in a pivot table. I have created the table but 1 of the fields I have that contains the description can be off the screen it's so long. When you float over the description for the record it appears fully in the yellow floating box. Is there anyway however to change... 7 May 2010 06:44
Working Time calculation - from text to short time I would like to generate report for those who late to work. But the database time is in text format, so i change it to short time using code as below. Is it correct ? & how do i set a calculation for total time late in HH:MM:SS as my working time is 09:00 Format(IIf(IsNull([dbo_Punctual.TrTime]),#12/30/2010#,... 7 May 2010 06:44 |