General :: Taking User Input While Opening Database

Dec 7, 2012

In my database there are fields of type Date/Time, their default value is set to now(). But the problem is that those fields are automatically filled up by English system date. I want my own country's date format, without changing my system date format. So I decided, whenever database is opened it should ask for a date, so the user will give today's date and that date will be used automatically on those fields.

View Replies


ADVERTISEMENT

Queries :: Taking User Input In CrossTab Query

Jul 29, 2013

I have a cross tab query that takes input from the user. The code is as under:

PARAMETERS [START_MONTH] DateTime, [END_MONTH] DateTime;
TRANSFORM Round(Sum(([A_GAS_m3]+[NA_GAS_m3])/1000000),3) AS GAS_MMSCM
SELECT maindata.on_off, maindata.state, maindata.OPERATOR, maindata.field_block
FROM maindata RIGHT JOIN PRODUCTION ON maindata.field_block=PRODUCTION.FIELD_BLOCK
WHERE ((PRODUCTION.MONTH) Between Format([START_MONTH],"dd-mm-yyyy") And Format([END_MONTH],"dd-mm-yyyy")))
GROUP BY maindata.on_off, maindata.state, maindata.OPERATOR, maindata.field_block
ORDER BY maindata.on_off, maindata.state, maindata.OPERATOR, maindata.field_block
PIVOT PRODUCTION.ACTIVITY;

I am facing 3 problems with the above code:

1. Access prompts to enter the start month and end month even when I click the save button.
2. When I run the query it prompts to enter the start month and end month twice.
3. I have generated a report based on the above query. When I run the report it keeps on prompting for start month and end month and does not give the final result.

Is it a common problem with cross tab queries?

View 5 Replies View Related

Opening Up A Report From A Form - However, It Requires User Input!

Jul 10, 2006

Hi,

I have a report that requires the user's input for a field called UserID.

I also have a form in which I want to have a button that can be used to print off this report (which would involve automatically entering the UserID into it). How do I do this?

Here is the code for the form button that I am using at the moment, but when you click it, Access still needs the UserID (duh!). So, how can I automate the input?

Code:Private Sub Command25_Click()On Error GoTo Err_Command25_Click Dim stDocName As String stDocName = "Menu" DoCmd.OpenReport stDocName, acNormalExit_Command25_Click: Exit SubErr_Command25_Click: MsgBox Err.Description Resume Exit_Command25_Click End Sub

View 5 Replies View Related

Modules & VBA :: Opening New Form And Taking Data From Another

Jul 19, 2013

IThe db has a form called ClientFormNew which logs client details into a table called Clients.Each client has a unique client ID in the table called ClientID. Sometimes Clients call back for further information and we want to log that information into a related table called ClientHistory.Each record in the ClientHistory table has a unique ID called HistoryID which is the same number as the ClientID so these fields are related.

When a client calls back and the telephone adviser opens up the ClientFormNew form and discovers they have called before they need to click on a button called Client History which then opens up the ClientHistoryForm..I am struggling with the code to put on the Client History button as I want the new form to display the details of the clients first contact then allow details of the second contact to be added in a new row. Also the new form needs to show all that client past history which would be in the form of the following fields from the ClientHistory table.HistoryID, ContactDate, Name, ContactMethod, ContactReason, AdviceGiven, Notes.

View 2 Replies View Related

General :: Auto Email After User Input

Jan 10, 2013

Access 2007 DB. Is there a way to have an auto gen. email sent to me and or other admin. After user has completed input into form...

View 1 Replies View Related

Forms :: User Login Form On Opening Of Database

Feb 17, 2015

I need to know the procedure or event code for user login form at opening.

I am working on database which is almost done and i defined tables for users with passwords.

I need to know how i can assign Login Form to be appear on opening of database no other person than listed users should be able to enter or open database without password, to enforce this i made a login form.

View 5 Replies View Related

User Input To Search Database And Create Report

Sep 9, 2004

I have a database that I created that uses a form to fill out information about server builds. I contains information about who built it, the IP address, server name, etc. I want to be able to create a dailog box that allows the user to input a server name to query the database and create a report based on that input. And if the user input isn't found in the database, a dialog box comes up with some sort of error message. I am still pretty new to Access, so the more detail you can give me the better. Thank a lot.

View 1 Replies View Related

General :: Combo Box To Show Name For User But Input ID To Tag Table

Jul 14, 2013

I have a AUCTION form, it has a combo box and the label for this combo box is called seller. This combo box is a look up to the USER table which has the following fields:

uid, uname, city, state

The combo box is pulling and displaying a drop down list of uname from the USER table, with this SQL state in the "row source".

Code:
SELECT user.uname FROM [user] ORDER BY user.uname;

In the control source of this combo box I have seller, and the form's record source is AUCTION, tagging on the AUCTION table.

The problem is the form is putting the uname into the AUCTION table's seller field, but I want it to input the uid field, however that it should still show the uname list when the user click on the combo box to make a selection.

View 2 Replies View Related

General :: Access Multi User Database - Error On Only One User

Apr 24, 2013

I have a multi user database in Access 2000 that is on a server. The individual users have shortcuts pointing towards the server instance. One user and one user only when opening the shortcut gets the error "you do not have exclusive rights to the database" .

All other users can enter the database with no error box. I have checked the advanced setting under options and they are correct. Ironically if you go to start and open access then navigate to the database shortcut. It opens with no error.

View 1 Replies View Related

General :: Getting Rid Of Password On Opening All Database

Jul 11, 2014

I was exploring using User-level permissions on databases so I, the admin, can have full permissions to edit/change etc. the database and certain users can only add/edit data. But I inadvertently have now set Access to ask me for a password for any db I open. Even if it's my own personal one. Can I set up Access to only ask for login info on certain db's, not all. I know that 2010 did away with User and group level permissions but was able to add it back through customizing the ribbon and adding this feature back to it.

View 9 Replies View Related

General :: Database Opening With Out Of Memory Error

Nov 14, 2014

In the database that I use at work sometimes when we OPEN it we get an immediate error saying out of memory, therefore we close it and reopen and all is good.

This is a problem when the average user logs on as they don't close it, they just continue on and then start experiencing issues.

I thought that the memory was supposed to clear when you close the database.

We run the debugger and no errors are ever found, we also run the compact and repair.

This can happen 1 in 10 or maybe 20 times when we open the database.

View 5 Replies View Related

General :: Database Opening In Read Only Mode

Sep 8, 2013

I am having problems opening my databases. Access automatically opens them in 'Read Only' mode, and I cannot find a way to avoid this - so I can never add data to the original tables ....

View 2 Replies View Related

General :: Holding Down Shift Key While Opening Database

Oct 16, 2013

Normally when I hold down the shift key when opening an Access database it opens in development mode. When I do this on a certain database it does not. It still opens in program mode. If I hit F11 it goes into a sort of development mode but I do not get the ribbon bar at the top etc.

Has something been set on this database to stop it opening in development mode? Can I switch it off?

View 2 Replies View Related

General :: Opening Access Database From Batch File Or VBS

Dec 20, 2012

Is there a way to open an Access Database from a batch file or VBS file wait for 20 seconds and then close the Access file. Preferably I would like the Access file to run in either invisible or minimized mode. I would like the Access Database to close again after the 20 seconds has elapsed.

(The reason for this is so that the Database can refresh itself from Sharepoint on another users machine so that the excel reports on his machine are up to date).

View 3 Replies View Related

General :: Show Loading Message While Database Is Opening?

Oct 23, 2012

I have a split database with multiple users. Since I split the database, it runs slower than the unsplit version. I understand this happens. I would like to have a message pop up when the database is loading. It takes approx 2 mins to load. Users get impatient and start clicking. So, I wanted to have a message pop up to let them know it is opening.

I have the same problem with forms loading, I have 5 forms and each takes about 4 secs to load, so thought about a loading message there too.

View 14 Replies View Related

General :: Opening Access Database In Code As Read Only

Jul 30, 2013

I am trying to open up an Access database as read-only from another running Access database. The code I have to open the database currently reads:

"""C:Program FilesMicrosoft OfficeOFFICE11MSACCESS.EXE"" ""f:commonpattyTraining Database.mdb", 1)

How do I change to read only?

View 3 Replies View Related

General :: Allow Colleagues To Input Data To Access Database?

Aug 6, 2013

How do I allow colleagues to input data to the Access database, but at the same time prevent meddling with the database design? Is it possible to password protect some functions but allow others (students/ nurses!) to input data?

View 3 Replies View Related

General :: Display Selected Form Using Drop Down On Opening Database

Jun 23, 2015

I have created a Db in MS Access 2010 and under Options > Current Database I have done the following:

- Used drop down to select a form I want to display on opening
- Unchecked display navigation pane
- Unchecked allow full menus

This works how I want it to, perfectly. I then send it to a client who also has MS Access 2010 and when they open the file the form I have told it to open doesn't open, the navigation bar is displayed (with the form I want to open highlighted) and the full menus show but are locked.

What's going on? Is it some security setting the client has that isn't letting the opening procedure execute properly?

View 1 Replies View Related

General :: One Button To Close All (Opening Access Database) On Server

Oct 14, 2014

Everytime i want to make some changes to my "Testing" Database , always got somebody using it / opening it...

I am trying to create a button , the function of the button is close "Testing" access database who using it or opening it , Example : 5 users included me in a company , when I click a button , 4 of them will received a notification with close "Testing" database message , can do that ?

View 1 Replies View Related

Forms :: Restrict User Input In Textbox Depending On What Option User Has Selected

May 22, 2013

I am building a form in access and I am trying to find a way where user input isn't possible in the associated textbox when "No" from on option box is selected.

View 3 Replies View Related

Data Entry - Not Always Taking In Database

Jul 27, 2006

I am having a problem where I have a form that I enter data into. Sometimes when I enter the information it will add a record to the table and sometimes it doesn't. It doesn't put the information in the table more times than it does.

I have tried to enter the information outside the form and it still does the same thing.

Do you have any suggestions of what I can do to fix this.

Thanks

View 3 Replies View Related

Database Taking Long Time

Mar 4, 2008

Hi there,

I have on MS Access database.which was working fine untill now but suddenly it started this strange behaviour.
When i open it it opens without any error but stays in the frozen state for like 5 mins means i cant do any thing or i cant click anywhere.

and after 5 mins it starts working fine.Does anyone have any clue abt this strange behaviour.

Thanks
Danny

View 5 Replies View Related

General :: Taking Two Records And Combine Them Into One

Jul 20, 2012

So I have two tables. One table "tbl_SRVASSET" lists out servername, serialnumber and asset tag. Second table "tbl_SRVNIC" list out the same servername, IPAddress and IPAddressTypeDesc.

The issue is that I have records in the "tbl_SRVNIC" with the same server listed numerous times (because it has 2 or 3 NIC's). So there is obviously a one to many relationship betweeen the two tables (common I guess). What I'm trying to do is be able to take the servers in the "tbl_SRVNIC" table and a new table or create a query with a single record for that server and have all 2, 3, 4 or maybe more IPAddress's assigned to them listed in the same record. This is what I'm having trouble with...

The end result is that after I've got this new table that lists only a single server and it's associated NIC's in the same record I can then combine that data with the "tbl_SRVASSET" via a basic query so my end result is a brand new table "tbl_SRVDETAIL" that looks like this:
SERVERNAME, SERIALNUBMER, ASSET, SERVER NIC1 IPADDRESS, SERVER NIC1 IPADDRESSTYPE DESC, SERVER NIC2 IPADDRESS, SERVER NIC2 IPADDRESSTYPE DESC, SERVER NIC3 IPADDRESS, SERVER NIC3 IPADDRESSTYPE DESC, (and maybe more columns if there are more, but that is a variable as some servers have 2 NIC's, Some with 3 or more so...).

View 1 Replies View Related

Taking Ownership Of Database-Access 2007

Dec 12, 2007

Just upgraded to Acccess 2007 and have ownership problem extracting queries from a 2002 db.

When trying to import into a new 2007 or export from the 2002, get "you have no permission" message

Have created a new user tried to change owner of the db, but no permission
File security looks correct in that I am owner of the file with full permissions, but Access doesn't recognize me as the owner

Tried logging in as admin, but it isn't the owner either

This is not critical, just very time consuming, this is a test project, but it would be nice not to have to rewrite about 30-40 queries and equivalent forms

Any guidence appreciated

View 12 Replies View Related

General :: Multi-User Database Access?

Sep 10, 2013

I created a database for multiple users, it seems only one user can be in database at a time. Is there a property that allows multiple users to simultaneously use database. My record locks property is no. Is there some other property that needs to be set ??

View 7 Replies View Related

General :: Viewing As User Would See Database Forms?

Nov 3, 2013

I want to develop my database and forms to fit a 1600 x 900 resolution screen and would like to know, whilst I am in the Developer mode of Access 2007, is there a key that I can press that will switch to display the database/forms so that I can see what the User will see?

View 2 Replies View Related







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