Search results for query: *

You can also set the default to UpperCase in the properity of the table. Select the field and in the field properity set the default value to > for all UpperCase or < for all LowerCase. This way you don't have to worry about converting the incoming data. Because you set the default in the...

the slpitting of the Backend and Frontend is a good start. when the response times of the database begings to slow down have your network admin check to see if there is any &quot;locking&quot; going on. Whether it be on your database or another one. The more &quot;locks&quot; that occurr the...

You might like to try this code. I can not take credit for it. Have used it in several applications I developed. Option Compare Database Option Explicit Function AgeInYears(BirthDate As Date, Optional AsOfDate As Date = 0) As Double '------------------------------------ 'Purpose: Get Age in...

what I have done in the past is to have a field in my table lets say &quot;MasterNumber&quot;, regular text field and a second field called &quot;num&quot; (autonumber) I then use the following code in the BeforeUpdate of the Form property- Private Sub Form_BeforeUpdate(Cancel As Integer)...

I have a table where the Authors Names all in upper case. I would like to via an update query call a module to make first character of name upper case. I lack the knowledge to know how to do a &quot;call&quot; thanks in advance

After doing some research: Create a new toolbar, in the commands section scroll to you find &quot;New Menu&quot; (should be at the very end). then drag the New Menu onto the toolbar. Then drag the other selections onto the New Menu, use the &quot;Modifty Selection&quot; button and click on...

I would use the toolbar customize and have your buttons on one toolbar: Exit| Open |Save |Close |Print and as you drag the buttons onto the toolbar you can use the &quot;Modifty Selection&quot; button and click on &quot;Begin a Group&quot;. This is a eaiser and cleaner way of making a...

I have a table that is used to order books. I would like to know who to take a the value of [qty]*[price] and have it show in the extended field of my table. I have tried an update query but that updates all the rows in the table

Can someone assist me in creating the code to display a message on a form where there is no record found. I have a song file 50,000 records.when a search is done and right now the only way I know it is complete and no record is found is the &quot;hourglass&quot; goes away. Thanks in advance for...

Can someone assist me in creating the code to display a message on a form where there is no record found. I have a song file 50,000 records.when a search is done and right now the only way I know it is complete and no record is found is the &quot;hourglass&quot; goes away. Thanks in advance for...

Disregard last Message, my mistake use this example uses the Left function to return a specified number of characters from the left side of a string. Dim AnyString, MyStr AnyString = &quot;FORD AUTOMOBILES ESCORT&quot; ' Define string. MyStr = Left(Automobile, 17) ' Returns...

use this example uses the Left function to return a specified number of characters from the left side of a string. Dim AnyString, MyStr AnyString = &quot;Hello World&quot; ' Define string. MyStr = Left(Automobile, 17) ' Returns &quot;Escort&quot;.

If your BackEnd has all the &quot;forms, reports, macros and modules&quot; you should be OK. If not Import the forms, reports, macros and modules into the Backend. Rename the Backend (InventoryBackEnd.mdb, to Inventory.mdb). How many concurrent users do you think you have. I encountered...

Here are a few more: http://www.ulster.net/~hfeddema/ http://rogersaccesslibrary.com/index.htm http://easyweb.easynet.co.uk/~trevor/AccFAQ/

if you use a macro autoexec to open your app hold the Shift key down. If you use tools start up, once the first screen appears hold down the &quot;ctrl and press F4&quot; If the database window is closed press &quot;F11&quot; HTH

another way is to create a button that when pressed will open form b. for the OnClick of the button create a macro echo openForm (in the properties this is object form) and form name form b SetValue Item [Forms]![form b]![value from form a] Expression [form a value] do as many setvalues...

try something like this, i am currently using this code to take a value from the input form and posting the vale to another table. Private Sub Form_AfterUpdate() 'For new records take item and classification info and adds to shipping/processing tables DoCmd.RunSQL &quot;INSERT INTO tblShipping...

You could always use &quot;SetValue&quot; where the value of the open form well post the the table2 AfterUpdate. Can be done via code or macro

based on your input mask you want to have leading zeros in the month and day. aswell as a full year. do you do any validating on the entry such Month >=01 and <13. fro the Day >=01 and <32. By doing this you will catch all invadil months and days. You can do the same for Year if you want.

I have 3 forms. I use form 1(Song Book Title) &quot;setvalue&quot; to insert the &quot;CallNumber&quot; value into a form2(Song Occurrence) and a &quot;setvalue&quot; to insert &quot;IdNum&quot; value into a form3(Song). this procedure works works great the firtime thru. Now I need to create...