Search results

Using 2013. How will I put it?

There is no Field Type to Calculated Field.

Where should I put that function, is it after update, on change or anywhere else?

I just need it to show how should it look like when in completed base. That's why I need to reflect it everytime I change one of the fields.

I have 4 text fields, Last name, first name, middle initial and full name. I need to update full name text field every time last name, first name and middle initial is being populated. When first name is populated , update appears in fullname then when last name is populated it will be...

What file is it ? my computer can't read it. Thanks.

I already looked in for the links you provided, what i need is a code in msaccess that Textfield = GetUTCTime TextField values may display (UTC + 01:00)

Hi Experts, How can I read the UTC time of the current station i am using. What I need is to detect and record it. (UTC+01:00) Please provide the function to be used or just give me the code to use. Thanks.

I have a Query which can pull data to a form, then the form will evaluate the ID, after saving/recording, I need to delete the evaluated data on the query. My problem is how can i delete it? There is Table1 for outputing the evaluation, Query1 where the evaluation can get the Data. Process...

Hi can anyone help me with this? thanks.

qry_SubCount2: SELECT qry_SubCount.MTransID, Count(*) AS SubCount FROM qry_SubCount GROUP BY qry_SubCount.MTransID; qry_SubCount: SELECT MainTable_Broadband.Activity, MainTable_Broadband.TicketID, (Left([TicketID],InStr(1,[TicketID],"-")-1)) AS MTransID FROM MainTable_Broadband GROUP BY...

I am not familiar on how would I use the link you gave me but anyway thanks for that info, The TicketID data type is "Text"

Its an expression from a query, MTransID: (Left([TicketID],InStr(1,[TicketID],"-")-1)) How would I know if it is numeric?

Hi, Ive been encountering this error, "Data Type Mismatch", can anyone help why i am getting the error? If IsNull(DLookup("[SubCount]", "qry_SubCount2", "[MTransID] = '" & Me.txtTxnID2.Value & "'")) Then Me.txtSubCount.Value = 0 SubCountID = CLng(Nz(Me.txtSubCount, 0)) +...

I dont know the main reason why it is crashing down,, it makes a backup copy then when using the tool again, it can be no longer used.

i have a database and it is repeatedly crashing down. Everytime it crashes, it lost its data and no one can ever use it again. CAn i prevent the database from these kinds of scenarios? Thanks.

I have this database, and it was always customized every month. Is it possible if Access will customized the form using a form? The form has a category Order and under Order there are different order names to be checked, is it possible if the user will just add another order name and it will be...

Is it possible to pull the data real-time? I have this access database, and I need to pull the data every time it was updated. Process name is given, I need to pull the time according to the process name and the volume, Attached files is the output. The output should be in a form.

No.. its just a one form..

------------> Field Names (TextField Label) Username: m48325 ------------> Username Date: 3/11/2014 ------------> Production Date Activity: Processing Order ------------> Activity Reference ID: 54351060 ------------> Document ID Numbers: 20128814 ------------> Subscription Status: Complete...