Hi all,
Seemigly simple question but can't satisfy myself with the correct answer.
Two MVP based views. On one view you click on an item in a list. Click a button and then the details of that item are displayed in another view. My question is how does the summary view pass through the state to...
Hi,
I'm using a TextBox to provide output from a process that a utility i'm writing runs. Now i thought this would be a simple case of calling the AppendText method each time a new message was ready to disply. But no. For the first 1000 or so message all it fine, but then after a certain point...
I've got a method that i use to convert a byte array into a System.Drawing.Image. The code looks like this:
private Image ConvertByteArrayToImage(byte[] bytes)
{
Image image = new Image();
using (MemoryStream ms = new MemoryStream(bytes, true))
{
ms.Write(bytes, 0, bytes.Length)...
Hi,
I'm not sure if this is the right forum to be posting this in, if not could you please point me in the right direction.
Basically i'm having trouble with layered data and header. (i'm probably using the wrong reminology here as i'm a bit of a noobe in this area).
Below is a simplifcation...
Hi,
If i create a workgroup file for a data base and then move both the database file and the workgroup file to another computer, will the database still work? I think it will but can't test it at the moment. Its just that i remember seeing somewhere about registry keys being created when the...
Hi,
Is there anyway that you can force Access to print another report every 9 records?
I have page header, invoice id header and a detail section with associated footers at the bottom too.
For every 9 elements in the detail section i want to print the invoice id header section again. I can't...
Hi all,
Having a rather silly problem with SQL insert in access
Basically i build an SQL insert statment as a string and one the values i put into it is a string e.g.
Dim test as string
Dim SQL as string
test = "Hello"
SQL = "INSERT INTO Testtabel([Astring]) VALUES('" & test & "')
This...
Hi,
I've written an SQL query thats designed to increase all the values in a field by a specified percentage. This is the SET part of the query
SET Rates.[Unit Cost] = Rates.[Unit Cost] * " & actualrate
Unit Cost field is set to Curreny with 2 decimal places and actual rate is a number such...
Hi,
I can't figure out if this is a problem with my printer or a problem with access.
I have lines in the detail section of a report that don't print and yet some that do. I'm using horizontal lines to make the separation of elements clearer so that i have one horizontal line the width of the...
Hi,
This isn't a big problem jsut an annoyance.
Sometimes when i'm working with the VB editor the tab key no longer works as the tab key but task switches windows instead.
I don't know what i do to make this happen so i have no idea how to turn it off. I assume i pressed a key by accident but...
Hi,
I've had headaches trying to get dialog boxes to size to what i want them too. Trying to make a dialog symetrical so that both margins of it are the same width.
Well here is something stumbled upon recently.
Turn of the rulers.
I never use them and i've never heard of anybody who does...
Hi,
I'm trying to get at the number of records in a form. I'm currently using the code:
records = Me.RecordSource.RecordCount
but i get the error message invalid qualifier in reference to the '.RecordSource' part of the code.
The form has its record source set by another bit of code to and...
Hi,
I've got some SQL which i use to populate a list box which is in a subform. The list box has the following SQL as its row source:
SELECT Contracts.ContractID, Contracts.Description, Providers.[Provider Name], Contracts.ClientID FROM Providers INNER JOIN (Clients INNER JOIN Contracts ON...
Hi,
I have a main form called AddEditClients with a subform called AddEditClients. The subform has its row source set to a table called clients. The Main form has a list box that shows a list of all the clients and when a user clicks on a client the sub for is updated to show the details of...
Hi,
Does anybody know of a way i can add my own folders to the windows XP start menu on the right hand side i.e. the bit where 'My Computer', 'My Music', My Network Places' is. I know i can turn the ones that are there on and off or change them between lists and link but i want to add my own...
Hi,
I've been suffering with this for a while but i've finally had enough of it now.
If i try and save my project when there are more than 2 access forms that need changing (basically when it tries to save two access forms at the same time) it fails to do so and locks up.
I get a warning...
Hi,
I have a table full of payments which are all uniqe. I want to be able to run a query that will return the sum of two values in a number of records with the same value in a paticular field.
So: the table payments has the following fields:
PaymentID (autonumber and primary key)
Subtotal...
Is there a way of accuratley sizing forms off the grid?
Currently i have to drag out the detail section of the form to the size i want then match up the edges of the actual window to the edfe of the detail. This seems to work but is there a more scientific was of doing things?
Why can't i just...
Hi,
I need to run code each time a report is printed to basically update the status of the invoice represented by the report. I used the OnPage event of the report for this but found that this code runs when the report is both printed and previewed.
I want my code to run only when the Report...
This is a rather bizare problem
i have a report based on a Query that basically is an invoice.
My problem is that although i have put various boxes and lines on the report they do not come up on a printout. Only the text/pictues and date print out. The lines and boxes show up on the print...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.