Home » Access » Page 1
Start of Day and End of Day Process
Category : Access
Hi guys.
In my database i need two process in the database one is SOD(Start of Day) and the 2nd one is EOD (End Of Day).
The purpose of these process to run multiple hidden queries in back-end. In both processes there are several queries to run.
I need help to setup this.i have no idea that how i can built this but this is necessary for database.
another thing these proces

View Replies

TAGS : Start Process

Word / Acess mail merge
Category : Access
When I am doing a mail merge from MS Word (3013) to MS Access (2013) I encounter the following problem:
After selecting Mailings > Select Recipients > (db) I get the dialog box that is small and transparent (see smallCroppedZip attachment). It should look like (see largeCroppedZip attachment) The first time this happened it drove me crazy, until I figured out that I could grab th

View Replies

TAGS : Word Acess mail merge

Textbox and contents will not display
Category : Access
Can anyone help please
Me.TxtNotAllowed.Visible = True
dtTimer1 = Now
dtTimer2 = Now + TimeValue("00:00:10")
Me.TxtNotAllowed.Value = "You do not have permission to use this database !"
Do Until dtTimer1 >= dtTimer2
dtTimer1 = Now()
Loop
Me.TxtNotAllowed.Value = ""
DoCmd.Quit
The above code will run definetely

View Replies


Select Query Problem !! $ !!
Category : Access
I'm having a problem get a query to select all of the records it should be.
When I filter the source table (200_STANDARDIZED NRGL) to show the data I want to see (PC2 = 6000; GAAP = 02; CGL = 0950, 2735, 2736, 3500 and 3501; STD VENDOR NAME = blanks), I get 33 records.
NOTE: Had to take the PC2 records that were not '6000' out of the dB I've attached in order to be able to send d

View Replies


Getting Data from Table based on text boxes
Category : Access
Hello, my problem seems to be very familiar to the one in this thread :
http://www.access-programmers.co.uk/...d.php?t=234613
Basically I have a list of tables in one combo box.
I want the user to select which table.
( The tables are stock information, each table for each different day of the stockmarket)
Then they select the Stock they want to look at. ( These are th

View Replies


Cannot open form by double clicking list box
Category : Access
When double click the entries given in the attached database I cannot open the correct form. it gives parameter value.
kindly help me to overcome this error.
Fox

View Replies


open the dropdown box on sub form in VBA
Category : Access
Hi,
Wonder if someone can help.
I want to open the dropdown box on my datasheet view subform from the main datasheet view form when I run over it with the mouse.
From my main form textbox [WelderID]
I tried this code but doesn't work. I get the error invalid reference to the property Form/Report.
Private Sub WelderID_MouseMove(Button As Integer, Shift As Integer, x As

View Replies

TAGS : open dropdown form

Error 2391 Field f1 Doesnt Exist In Destination Table, Access 2013
Category : Access
Dear Expert,
I'm getting error 2391 field 'f1' doesn't exist in destination table
Code:
Dim FileBrowse As Office.FileDialog
    Dim varFile As Variant
    Dim sFile As String
    Set F

View Replies


Query taking information from form problem
Category : Access
I have set up a form to allow for new students to be added to the database. I have connected the form to a query that is called upon when the user saves the form. The query is meant to take the information from the text boxes on the form and add them to the students table. For a reason unknown to me the query is adding the new student into the table the amount of times that there are records

View Replies


DAO Help
Category : Access
I am having trouble with the below returning the correct number of records, and can't see why.
I have one table, tblDevice, which has 4 columns, ID | DeviceRecNo | ExcludeFromCheck | StockLocationID
ID - Autonumber
DeviceRecNo - Number
ExcludeFromCheck - Number (1 = yes, 0 - No)
StockLocationID - Number
I have the following running as part of some code, but it is

View Replies

TAGS : Help

General Date Format: Missing Time
Category : Access
I have set a field on my FORM with the General Date format. Every time I use the date picker it inserts the correct date with a time of 00:00? I even changed the format on my table to general date - still no luck
I don't understand why?

View Replies


Form and subform, parent and children in a transaction
Category : Access
I have a parent record and child records. After creating the parent, there must be at least one child record.
On closing the form I could, in principle, delete the parent and child (or children), if the user changed his mind.
Or, I could presumably wrap this entire enterprise in a transaction, something along the lines referred to here: http://www.access-programmers.co.uk/...d.php

View Replies


access 2003 to vb.net and sql server
Category : Access
I wrote a database in Access 2003 which is shared between about 15 to 20 users. i.e they have similar front ends but all access the same back end mdb
Now my company are wanting to move the back end to sql server but have the front end in VB.NET and not Access. I guess you cannot do a simple conversion so the whole front end will have to be written in VB.NET. I am not doing this but

View Replies

TAGS : access 2003 server

Why am I getting two PF & not one PF or FK using DeZign
Category : Access
Hi I am still learning this ERD stuff and am trying out DeZign for a MSSQL database and I thought I had PK and FK all figured out now im am reading about PF and trying to understand.
Reading about identifying I thought the CL_Address table should just have the "PK clAddressID" and "PF clClientID" as the Primary Key. Why is it adding the other PF key ??
EDIT: oka

View Replies


Leading zeros :
Category : Access
I have an alphanumeric primary key that goes
REF0001
REF0002
REF0003
e.t.c.
When i get to REF9999 and enter REF10000 it does not store it after
REF9999 but stores it after REF100. Why is this ?
Is there a quick way that i can add leading 0's onto my records
so it will read
REF000001
REF000002
REF000003
e.t.c

View Replies

TAGS : Leading zeros

Select query returning the string instead of the value
Category : Access
Why is strCreditCheck returning the actual query string and not the result? Of course, this is not working. Please help.
Code:
Private Sub b_PrintWorkOrder_Click()
    Me.Requery
    Dim strCreditCheck A

View Replies


Functional keys to perform commands
Category : Access
Hi all.
Could some one tell me that can we use functional keys F1, F2,F3,,,,,,,,,,,,,,F12 in ms access to perform commands like saving a form data , for closing form refreshing form, clear form.
Or is there any way to make shortcut keys combination like[(ctrl+s)(ctrl+c) (ctrl+A)] in access to perform action like saving,closing,clearing, current form.

View Replies


How to get a current user from a custom login form
Category : Access
Hi friends, can some one like to tell me that how i can get a current user from a custom login form CurrentUser() this function always return a system user name admin as default. In my login schema i have a Hidden splash form that have a unbound field that holds user name from custom login form after login a dashboard execute and also display user name on dashboard according to user login

View Replies


Also Filtering using a check box
Category : Access
So I'm trying to figure out how to filter a report using a check box.
I have created a form, which if you push an industry labled button on that form it will show you the report with what work was done for that industry.
Now I'm trying to modify it so that I have a group of check boxes; each check box being a different office location the company has.
What I want to make happ

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .