Auto Day

Mar 11, 2005

Is it possible to have a select query which has a where function that automatically includes the Day?

In this case I don't mean the date, but something like "Tue" or "Wed".

Or is this only possible to have the user enter this himself?

Greetings and thanks again,

Lion85heart

View Replies


ADVERTISEMENT

Auto-trim / Auto-crop A Picture & Screenshot

Mar 20, 2006

we use access database for printing lab reports. and a small graph is also printed on this report from another software(not an access application).

what i have done is that first we print the txt report from access and then use the same paper to print graph on it. I have alligned the report in such a way that these two reports fit perfectly.

we have to print twice and sometimes the graph is deleted in the other application, so we have to make the graph again.

what i want to do is:
1) prepare graph in the other application.
2) take a screenshot of it.
3) save this as an image file (jpg or bmp)
4) reference this picture in the access application and print it with the report.


So the problems are:
1) when i take a screenshot, how do i save it as a file,
2) how do i just get the area of the graph and remove all extra space. (usually all the other space is white as background)

View 6 Replies View Related

Auto-insert And Auto-update Help

Sep 1, 2005

Hi all!
I was wondering if you guys can help me out with this one:

I would like to have data auto-inserted from a particular colum in table 'x' in to a defined column in table 'y'. similary, I'd like to achieve auto-updation of this data as well as deletion. Can anyone please provide some guidelines?

A little more detail :

I have a column "Client ID" in the table client_personal_info, the rows of which I'd like to have updated in the "Client ID" column in the client_business_detail table.

So if say, ClientID_1 is a row that has been added by the user, I'd like to have it auto-inserted in the client ID column in the client_business_detail table

thanks in advance for your help

View 5 Replies View Related

Modules & VBA :: Name Auto-Correct Off But Auto Changes Appear

May 22, 2014

Access 2010 keeps changing the Capitalization of objects when I don't want it to.

For example "Cancel" becomes "cancel". Later it will be changed back to "Cancel".

There is also a table with a field "FULLNAME". Several Queries build a field "FullName". As a result FullName, even in places like Application. CodeProject.FullName get changed to Application.CodeProject.FULLNAME.

(Track Name AutoCorrect is off. ) It is especially irritating because I export the code to text files and check it into source control. Sometimes dozens, or even hundreds, of files will show up as changed because Access did it's rename thing.

View 3 Replies View Related

Appending Records With A Desired Auto Number In A Table With Auto Number

Oct 26, 2005

Here is my issue. In a table with an Auto Number index some records have been deleted. I have been able to recreate them along with their original auto number. The problem is that I do not know how to append these records forcing the original auto number. I have tried changing the auto number field to a number field in the table, this works except I cannot change it back to auto number.

I am sure I’m not the first with this question or issue. I did search through a couple hundred entries about auto number before I posted this question.

Jim

View 7 Replies View Related

Auto Fill

Jun 8, 2005

I've tried googling this, but I can't find anything helpful. I have five columns in my 'Main' table. In each row, column B, C & D are solely dependant on column A. And column E is completely independant of all of them. I want to be able to select a choice in column A using a drop-down menu (which I know how to do) and have columns B, C, & D automatically fill themselves in (which I don't know how to do). Column E I would just manually enter.

How do I get columns B, C, & D to automatically fill themselves in my 'Main' table. I would select a value from a drop-down menu in column A and want everything else to fill in. The values for A,B,C,& D are all in seperate tables with an ID and linked to their respective fields in the 'Main' table. Appreciate any help.

View 1 Replies View Related

Auto Colours??

Nov 18, 2005

Hi all,
Is it possible to have different colour fonts in forms automatically?

i want the user to add numerical data into the form but the middle numbers must automatically be coloured red. these numbers are then matched to stickers in the same format for easy identification.

it should look like this 878802

any suggestions?

Many Thanks
Sam

View 2 Replies View Related

Auto Update Of A Db

Nov 24, 2005

If am a developing the db and just making alterations to forms and reports etc on a developing copy. Is there anyway i can auto pull and replace the ones in the live db rather than going into the live db, deleting all the forms etc and then importing it?? can it be scripted or somethign like that?

Thanks

View 1 Replies View Related

Auto FE Update

Dec 21, 2005

hi all
i searched for this but didnt get it clear. how can i update the FE for my users?

View 1 Replies View Related

Auto Number

Dec 29, 2005

I make a data base every year for work orders that my work does for our customers, I have every thing set up and it looks great except for one field, last year I was able to make it do an auto number once I put the date in. for example first box work Order # ___ second box date once I put in the date an work order # would fill in the w/o# box and it would follow what ever the last work order # was (12600). for example I need the year 2006 TO START OFF WITH # 12601, What querie/option do I need to accomplish with this info.

View 2 Replies View Related

Auto Update..how?

Jan 19, 2006

Hi...Im working with this database..its an order tracking database.. everytime we received the shipments we have to update the rcvd items.. i have an attachment here... pls i really need help...

How could i do these automated:

1: if i update the Rcvd status (Y/N) "Y" ...how could i make the Date Rcvd automated.. coz what happens is that.. i have to put date in each items that we rcvd and its a waste of time.. what if.. i have lots of rcvd items..

2. how could i put row count.. so i could know how many items i have and on what row are they...

pls help..

thanks in advance....

Eric

View 5 Replies View Related

Auto Sort Anyone

Jan 25, 2006

I have a table already set up in a Subform of a main form

The Table has values like
-Date
-Time
-Name
-SchBy

I want to have the subforms table to automatically re-sort ascending by Time, how would I go about doing this so the user doesn't have to click the field then sort ascending button...?:confused:

View 1 Replies View Related

Auto Backup

Apr 20, 2006

I was thinking of an idea to backup the database in a multiuser (FE/BE) environment, without disturbing the users. Please comment on it as if it has any drawbacks.

And also soemeone please help me do this, if its does not contain drawbacks.



************************************************** ********
Main Idea



What I want is to automate backup process at fixed intervals, in a FE/BE environment without disturbing the users i.e without disconecting the users. And I think it is possiblke and safe to do if we start the backup process when all users are inactive and stop any user activity or stop Frontend's interaction to the Backend, while in the backup process.

And If no such time is available as all users are inactive within a certian time then forcefully stop user interaction to the backend and start backup process.




************************************************** ********

How to:


To stop user interaction with the backend , we can close all objects (forms, reports, queries etc) and open an unbounded modal pop-up form , with no close exit button. This form can have timer and after 30 seconds or maybe 1 minute we can auto close this form so that the user can again use the application.
We can stop new logons by placing an ini file in the folder where the Backend rsides. This Ini file can contain two keys ( "lock time" and "lock status"). At the frontend startup we can query these value from the inifile to check that new logons are allowed or not, and if the "lock time" is greater than 2 minute then bypass the lock status and allow new logons. It means that something went wrong with the last backup process and the ini file was not updated to new lock status.
We can have a table or an in file store the normal and maximum time at which the backup process starts. These values can be queried and compared with the current time using a hidden form. If the normal time exeeds the current time then start looking for a state where all logged on users are inactive (i.e all objects are closed in the front end of all users). If such a state is found then warn the user that backup is going to start in 1 minute, lock new logons, after 1 minute close all open objects and then bring up a modal form that i have described in step 1 and start bakup process. And if no state is fount till the maximun time then warn all users that backup would start in 1 minute, lock new logons, after 1 minute close all open objects and then bring up a modal form that i have described in step 1 and start bakup process
After the backup is complete set allow new logons in the inifile.

View 1 Replies View Related

Auto Center

May 19, 2006

Why is it that auto center doesn't auto centre? Yes it centres horizontally - but not vertically. Does anyone know how to actually center horizontally and vertically i.e centre!? (I have used both spellings in order to appeal to a larger audience!)

View 4 Replies View Related

Auto Email

Oct 30, 2006

Can someone please look at this and help me as it does not work? It stops right away at the "Dim olApp As Outlook.Application". It tells me "user-defined type not defined". I have searched the forums and could not find a solution.

Thanks,
RichB



Private Sub Command154_Click()
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.Application

'Create e-mail item
Set objMail = olApp.CreateItem(olMailItem)
With objMail
'Set body format to HTML
.To = "Forms!FrmPersonal!Email"
.BCC = Forms!FrmPersonal!rateremail & Forms!FrmPersonal!rrateremail
.Subject = "AUTO EMAIL REMINDER"
.BodyFormat = olFormatHTML
.HTMLBody = "<HTML><BODY>Blah, Blah, Blah</BODY></HTML>"
.Display
End With

End Sub

View 2 Replies View Related

Auto Responder

Feb 27, 2007

Hello I am going to be developing a site that will need to give qoutes.

So person will fill out a form and when they send the form. They will receive the exact about of money it will cost them

So I fill out a form asking how much will such and such cost, I send it in
With in 2 or 3 minutes I receive an email with the exact amount of the cost.

Can this be done with access database..If so or how would I approach this situations. Remember this is an auto response with the exact answer I was looking for from the form I filled out.

Thanks for all you help

View 3 Replies View Related

Auto Labelling

May 29, 2007

Hi,
I have created a database in access to build an inventory. The structure is very similar to the "Home Contents Inventory" template from microsoft.

I want now to generate auto-labels for all contents in the inventory in the format XXX-XX-999 (XXX=Room, XX=Device, 999=number of devices in room) so for example if I have three PC's in the OfficeSpace room the label should be OFS-PC-003

I have created fixed value columns for Room and Device with the abbreviations stored all I need now is to somehow concatenate these two columns and assign an autoUpdate number so that the Label remains unique throughout (OSF-PC-001, OSF-PC-002, PSF-PC-003, BOR-PC-001 etcetc)

Can anyone help me sort this out?

best regards

View 4 Replies View Related

Auto Refresh

Jun 1, 2007

I have a form with four subforms which display highest scores in four categories during a competition. At the moment I have to manually refresh the form to see the latest scores. How can I get this to happen automatically say every 2 minutes?
Thanks Dennis

View 1 Replies View Related

Auto FE Updater Help

Aug 8, 2007

I am using the Auto FE Updater to update the FE's of my database over a LAN. The utility is setup and working normally for the most part, but I have one little issue that I can't seem to find any info on anywhere.

There are two groups of users that are only separated administratively (not geographically), they are in the same building. One set has their drive containing the database FE & BE mapped by a logon script; the other group must map the drive manually. The problem is with the second group; they can't map the drive to the same drive letter because they have another drive automatically mapped to that letter in their logon script. Plus since they are doing their own mapping, they don't map to the same letter amongst themselves. I am using a shortcut to the StartMDB.exe on the network drive (the shortcut is in a separate folder from the actual executable). I am using UNC everywhere possible but when the shortcut is put on the desktops of the second group it still points to the drive letter of the first group. If I try to change the shortcut to UNC it always reverts back to the letter it is mapped to.

I am trying to make a .cmd file so I can use UNC there but can't get it to work. Does anyone have a .cmd file that starts an exe and points to an ini file as would be needed by Auto FE Updater? If so could you post a copy of it so I can see what I am doing wrong? Also, does anyone have any other suggestions?

View 5 Replies View Related

Auto Fill

Aug 14, 2007

Hi

Does anyone know how I can auto fill all the records of a field by just entering it once

Thanks

View 2 Replies View Related

Auto Shutdown

Nov 8, 2007

Hi

Does anyone know if it is possible to create a macro (or whether there is another function) so that a database will automatically close after a period of inactivity.

There is only one form that users will see (or use) but if this form remains inactive for say 20-minutes the program shuts itself down.

My initial thought was to use Form>On Timer facility but I would need to be reset the timer after every update. This seems particularly longwinded and I'm not 100% sure it would work.

Any suggestions would be gratefully received.

Thanks.

View 2 Replies View Related

Auto Fill

Jan 17, 2008

I am looking to find the experssion that will allow me to put a date in a query under date completed and have it fill another field for schedule.

I know that in Excel it would be =sum(A1 +90 ) and this will give a date 90 days after the date inputed into field A1 and so on down the column. and it would auto fill the next column for me

View 2 Replies View Related

Auto Increment Value

Mar 23, 2008

Hi All

How to assign value to a field based on the value of the same field in the previous record?
Autonumber has its limitations for my purpose. Because, after I start filling up a form, I some times cancel the form filling process, and it affects the continuous numbering.

I guess the issue can be resolved by using some thing like record count facility. i.e. current' record's field value = number of records till previous record + 1.

How to exactly codify or execute the above by vba coding.

The Field Name is "SerialNo.", and Table Name is "StudentData"


Thanks

Padhuka

View 5 Replies View Related

Auto Complete

Feb 2, 2005

I am new to Access, I know I couold do this easily in other DBs using a dependant relationship... but I can't get a handle on it here.

I have Client, a State and Coutry tables. What I want to do is assign a Country to a State (in the State table?) and then when I choose a State in the Client table, the Coutry field is completed automatically.

Any ideas?

View 1 Replies View Related

Auto Number

Jul 10, 2006

are you able to do something with the auto number.

i'd like it to display R/N "month" auto number "year".

i cant seem to get it to display the month and year

View 5 Replies View Related

Auto Completing

Jul 4, 2007

I have something that is really taken up too much time and also given me a headache...
I have a subform related to a main form....cool no problems there. I am using a couple of fields from the main form within the subform and adding dates, names and contact details to associate with the relevent records.
Can this subform facilitate the autocomplete phenomina that i see in windows and excell and the like so i dont have to continually type the same names.
I tried to select names from a combo box but it got messy and names were being overwritten by numbers and i nearly broke my screen...lol
Wanting to get functionality back in to this app at the moment, and suggestions are eagerly sought:confused:

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved