Search results

Try changing: to IIf (Not IsNull([Forms]![FFRRCheck]![Text305]) Otherwise, are your sure it ever results in the carriage returns? It's a complex statement. Have you tried breaking it out to multiple controls and putting it back together in another control just to make sure it is all firing...

Tighten up your report to increase the size of your margins that your printer will still be able to print. If your using 8.5 x 11 paper, try to keep your report to 7 x 9.5.

Where else can a few lines of text be so much fun. :D

Derek, I added form1 with the button and controls you will need to run the function. Let me know if that works for you.

this code should be run in the data entry form in the forms Before Insert event. The Before Insert event will fire upon your first action when entering data. You will need to replace my generic identifiers with your specific names. If Dcount("*","tblYourTable","[RandomNumber]=" & TestNumb) =...

Hi Derek. The attached file has a function called TransCol that is in Module1. To run the function you can either go to the immediate window and run it from there or attach it to a button on a form. Let me know if you have any problems.

If you want to post your DB I can take a look, it's odd so I'm guessing it will something simple.

Thanks Rainlover for jumping in. In this case I'm sure it is even needed but I didn't know how Gambit17's data was structured since his ultimate goal was not to have duplicates.

Have you worked with recordsets in VBA? To do what you would like you would need to parse through your recordset and assign the data to the new tables fields. If you have a DB you want to attach and I can set it up for you.

Using the default value does not affect the Control Source and is a good way of guiding the data entry process especially for fields that don't change much. Try changing the code: Me.Complete = Date() Me.Update = Date() Just a consideration, Update is a reserved word and although you can...

Are you saying you want one long row for each Column name? For example, the current table has 20 records so you want all 20 Customers to be on a single line and then 20 Names on another line etc.? If so, your new table would have only 2 columns, the first column is the name of the column from...

Since you do not want to directly filter by the result of the checkbox, you will need to set up some type of logic to discern what to use for the criteria in your query. You could add 6 invisible controls to your form to hold the criteria values, which are 0 for false and -1 for true, and...

1) Why a random number? Instead consider using field type Autonumber and allow Access to add an incrementing number. 2) If you want to verify the new random number is unique you will need to use VBA code, a query can not do that. Dim TestNumb as long GetNewNumb: TestNumb =...

Please post your code that is performing the autofill. A suggestion, set the default value for this date field to Date() and that will be the current date and may alleviate the need for a button.

On your report create 3 additional controls GetStart, Increment and DisplayNumber. For GetStart, the Control Source should be something like: [Please Enter the Starting Number] For Increment the Control Source will be: =1 and set Running Sum to be Over All For DisplayNumber the Control Source...

That's good. Using a query inside a query could begin to get slow the larger your recordset as it needs to resolve the second query for each row in the main query and that means it needs to go through all your records in the table over and over and over again.

Try this: INSERT INTO [Cotton13/14] SELECT DISTINCT [Contracted Farmers].* FROM [Contracted Farmers] LEFT JOIN [Cotton13/14] ON [Contracted Farmers].[OF Codec] = [Cotton13/14].[OF Codec] WHERE ((([Cotton13/14].[OF Codec]) Is Null));

I've attached a small DB showing the use of an OLE Object. You should store BMP images as that is what is native to Microsoft otherwise you would need to ensure there is an OLE engine for other types but if your unsure, try it and if you see your image than you have that engine. You could also...

It looks like your Balance is a running sum of the QTY as long as you set your sort order to be by date ascending.

Could you give me an example of what you are looking for it to do. Is this calculating a total balance or is there a starting balance and you are subtracting transactions? Thanks.