Need A Flag In A Database

Sep 28, 2006

I need a flag(indicator) for my database. This flag would be read by many different functions and depending on the value of the flag, would do one of two things.

Example: If the flag is "A", when I click a button in a form it does "C" function. If the flag is "B", then in case of the previous button it will do "D" function.

What I'm having a hard time with is where to store said flag. Mind you the flag is either one or the other ("A" or "B") for the entire database, not just a specific record(s). I thought about adding a field to my 'master' table and then use an update query to change all the values from "A" to "B" as needed, but that seemed a bit like storing redundant data.

How or where should I store this flag?

View Replies


ADVERTISEMENT

Queries :: Look At Tables And Flag Database Changes?

Jun 25, 2013

I need to build a Query that will look at a previous table and a new table and flag any changes...what is the best way to go about something like this?

View 5 Replies View Related

How Could I 'flag Up' Dates

May 2, 2006

Sorry, I tried searching the forums with no luck.

What I need to do is.

I have a table with a field called intervention day, the user then types in that field a date, pretty simple huh.

Well anyway I need the system to some how alert the user when that date comes, either through an information box or whatever.

thanks for any help,
tom harper

View 5 Replies View Related

Flag Up A Warning

Feb 6, 2006

Hey there

there is a function that I wanted to do on my form but can't think of a way
what I want to do is to show up a flag after 14 days and 28 days of a date with missed appointment being ticked
say there are two fields in the section

AppointmentDate
Missed

Will I be able to do this in access?

Please advice
Cheers
Si

View 6 Replies View Related

Flag Dates

Mar 12, 2008

hi I was wondering if anyone knows how to flag dates in access. I have 2 dates entered and I need a flag to appear if the second date is a month longer than the first date entered. Hope this makes sense and hope you can help

View 5 Replies View Related

Using A Query To Add A Flag From One Table To Another

Jul 8, 2005

Hi, just so you are aware, I am totally clueless when it comes to Microsoft Access. I tried finding tutorials and help online that I could use to do this but I'm having trouble understanding what I'm supposed to do. I have two huge tables linked to each other by an ID number. One table contains multiple records with the same ID number while the other does not. There are records in the first table that don't appear in the second one, and there MAY be entries in the second table that don't appear in the first table. The second table has a flag that I would like to add to records in the first table that appear in the second table. What is the easiestt way to do this? This may be an extremely stupid question or it may be very hard, I'm not sure which, though I'm leaning toward it being a stupid question. Thank you in advance for your help.

View 4 Replies View Related

Flag Record When Printed

Apr 26, 2005

I print a certificate for each person attending my class by sending the form (StudentForm) to a report . To save time I print and sign certificates for all preregistered students then during class I enter all students that enroll the day of class. What I would like to do is flag each preprinted record so when I select the print button after all students are entered into the database all certificates except the preprinted records will be printed. Any ideas on how to flag a printed record?

View 4 Replies View Related

Current Location Flag

Jul 3, 2013

I have a list of locations in a sub form where a chart has been and the last record is it's current location. I'm generating a building report which should show a list of charts on that building, but it also shows it on old locations. So in the example, it shows for building 43 and building 83. I just need it to show on 83, how to accomplish this.

View 2 Replies View Related

Complex Duplicate Entries - How To Flag Up Etc.

Jan 8, 2007

Hi everyone,

I'm aware of the wizard in MS Access that creates a new table containing duplicated entries that have been entered under one column, however, my problem is slightly more complex...

A contractor of mine has recorded information from CCTV surveys of sewers (not very glamorous I know!) in a Microsoft Access database. If you can imagine - the camera can be pushed along a pipe from both ends. Sometimes, the survey is abandoned in one direction and then repeated along the same length of pipe but from the other direction. The database contains (amongst other columns) a "start manhole" reference and a "end manhole" reference.
eg:

16014

As you can see, the information contained by both entries will be the same (as they are the same length of pipe). Therefore, I was wondering how I could get MS Access to:
1. Recognise these 2 entries as duplicates
2. Create a table that hides the duplicated entry with a shorter "SectionLength" value.

Many thanks in advance.

View 1 Replies View Related

Flag Specific Criteria In A Field

Feb 6, 2015

I'm using MS Access 2010, how to flag a criteria in an age field like, Pop-up if age is under 14??

View 3 Replies View Related

Forms :: Creating A Favourite / Bookmark Flag?

Nov 5, 2013

I have a knowledge base database which lets the user search for articles containing answers to common problems and issues. Some of the users want to be able to bookmark certain useful articles. The DB is a front end/back end design so I am thinking if I have one table stored in the front end which can be used to store that particular user's favourites then that would be great. However, I a little stuck on how to implement this. Ideally, I'd like a simple checkbox option next to each article, which when ticked, would store that article ID in that user's local front end.

View 3 Replies View Related

Forms :: Display Flag Corresponding To Selection In Combo Box

Apr 18, 2015

I'm trying to create an access database to make an inventory of my model trains.

I have a main entry form (frmTrain) where I enter all sorts of info regarding e.g. a locomotive. This info is then stored in a table (tblTrain).

In the main entry form, I've put a combo box (cmbCountries) linked to a query (qryCountries) which queries the country codes from a table (tblCountries) that has three fields:

ID (autonumber)
CountryCode (short text) (containing the country codes UK, FR, DE, ...)
FlagFile (short text) (containing the name of the flag picture, e.g. UK.png)

The flags are stored as *.png files in a folder Flags that is in the same folder as the database file. I have chosen this approach instead of putting the flag pictures in an OLE field in tblCountries because I'd like to avoid being stuck to *.bmp files (don't support transparency). I'd also like to avoid having to mention the complete file path in the field FlagFile

I created a form (frmCountries) to easily add countries to tblCountries as needed.

Now back to the main entry form. The selection made in cmbCountries is stored in the field 'Countries' in tblTrain. When a country is selected in cmbCountries, I'd like that the corresponding flag is displayed next to the combo box.

I found an example on the web where an image field was used to display the flag, let's say with the following code:

Private Sub cmbCountries_Change()
Me.ImageFieldName.Picture = Me.cmbCountries.Column(2)
End Sub

Private Sub Form_Load()
Me.ImageFieldName.Picture = Me.cmbCountries.Column(2)
End Sub

and where the combo box had as row source (not using qryCountries):

SELECT tblCountries.ID, tblCountries.CountryCode, [Application].[CurrentProject].[path] & "Flags" & [FlagFile] AS Expr1 FROM tblCountries ORDER BY tblCountries.[Code];

The problem with this example is that, if you select in frmTrain e.g. UK, the UK flag is then displayed across all records in frmTrain. So the image field is not the appropriate field to display the flag in frmTrain and I guess an unbound/bound (?) object frame should rather be used.

How to display correctly the flag picture for every individual record in frmTrain corresponding to the country chosen in cmbCountries.

View 13 Replies View Related

Modules & VBA :: Assign Column Width In Flag?

Apr 29, 2014

How to implement the procedure of clicking on the flag and hide the field in VBA? I know that want to assign - ColumnWidth=0.

Сomplete procedure fails.

View 10 Replies View Related

Updating Query Flag If Child Records Exists

Jul 12, 2006

I have a stock-type record and a stock-item record.
I want to update a flag on the stock-type record called instock to be true if there are related stock-item records and false if there are no related records.
Does anyone know how to run a updating query that will do this?
I am fairly new to this so I'm sorry if this is a bit of a basic question.
Thank you for your help in advance.

John

View 1 Replies View Related

If Filed Hasnt Changed In 24hrs...flag It And Dcount The Results ?

Aug 3, 2006

Another question on how might be the best way to do things with dates ?

I have a simple database which is a fault database.

I get an email request to investigate something and I log it and give it a ticket number. If I email back , I put the comments that I sent in the email in the update field on the database.

When I create the ticket its in an open state with a date and time stamp of now()

When I close (drop down box with open and close as options) the ticket it automatically updates the time in the closed filed to Now()

What I want to do is when I updated my comments field , this sets a date value in a hidden field on the form of Now()

So then I need an expression that looks at the difference between the updated time and the now time

i.e. I update a call on 29/7/2006 at 10:00 am

Its now 30/7/2006 at 10:01

i.e 24hrs and 1 minute later

As its more than 24hrs this flags and output to a filed e.g. 1

I then total all the "1" and therefore I have a ticket count of how many calls have not been updated in 24hrs.

So Im assuming I will need an after update event on my comments field put today's date in this hidden field ,and then maybe some sort of code which is maybe on my switchboard which looks at the difference of these dates and if greater than (or equal too) 24hrs it will output a value of 1.

And If I can do this I can also have a flag if its more than 2 days , then clear the 24hr flag an increment a 24hr flag etc.

My tickets should all be closed with 24 hrs , so this is something to capture anything that is open and hasn't been updated in 24hrs

Id appreciate some guidance on the best way to do this ?

Cheers

Jimmy

View 4 Replies View Related

Question On Query To Flag A Field Based On Calculated Data

Apr 25, 2005

I have a table with numerous fields including timeIn and timeOut field (these are date/time format). I need to find out how many people were clocked in during each operating hour (based upon their time in and time out). How can I run a query that will allow me to use the times in and out to 'flag' each hour that each person was on duty (a new field for each hour) so that I can run a count on the completed data for every hour?

View 4 Replies View Related

Forms :: Automate A Membership Status Flag - Invalid Use Of Null

May 20, 2014

I am trying to automate a membership status flag based on comparing today's date and a recorded expiry date. The expiry date control is on a sub-form. I have the following code in the OnLoad event of the master form:

Dim DateGap As Integer
While Me.CurrentRecord < Me.Recordset.RecordCount
If Not Me.NewRecord Then
DateGap = DateDiff("y", Date, Forms!PersonalMasterF!MemberSubF.Form.MemberExpire )
Else
DoCmd.GoToRecord , , acNext

[Code] .....

With debug pointing to the DateGap = statement I get the error 'Invalid use of Null'. As you can see, I've tried to trap any new records it might run into to avoid nulls in MemberExpire, and there are no null values in the MemberExpire field of the underlying table. I've also tried defining DateGap as Variant, which does not work at all.

View 7 Replies View Related

Okay To Flag Status Of One Table In Another Table?

Jul 8, 2012

If you've got a library database with three tables: books, clients, borrowings, would it be okay to have a field in 'books' that flags whether or not the book is currently on loan - or should that fact always be elicited from a search of the 'borrowings' table?

View 2 Replies View Related

Database Size Limited To 2GB / Query Multiple Database Without Linking Tables?

Sep 7, 2011

I'm trying to set up a simple query that links four tables. However, the tables are extremely large, all in excess of 1.5GB each so I had to split the tables up into four separate DBs. I've tried the following with no success:

1) Link the 4 tables in the DB which contains my primary key. This quickly inflates increases the file size above 2GB and won't let me go any further.

2) Build a remote query to connect the four tables. This looked promising until I tried to run the query and it became evident that it only knows to point to the last database source that you specified.

I'm running everything locally on my C drive. The data source are simple text files (1.6 million rows) from the FDA website.

View 3 Replies View Related

Forms Count Of Other Database Without Opening That Database Physically

Oct 7, 2005

Hello All...

Well, I am facing one problem..in my application; I need to show all forms / reports name of other database( .mdb ) file without opening the other database physically. I tried a lot but didnt succeded. I tried with below code..

Set AcApl = New Access.Application
Call AcApl.OpenCurrentDatabase(strfolder, True)
Set AcProj = AcApl.CurrentProject

Set frm1 = AcProj.AllForms

intCount = frm1.Count

But here wen the second line AcApl.opencurrentdatabase get executed at that time the database get open physically, and i dont want that..So is there any other way around..If so..please please help me..

Thanks in advance..!!

View 4 Replies View Related

Modules & VBA :: Open Database / Run A Query / Close Database

Aug 22, 2014

i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.

View 4 Replies View Related

General :: Updating From Local Database To Central Database

Sep 12, 2012

Database: Access 2007

I have designed a touchscreen input system using Visual Basic.net and this writes to an Access Database. Each Touchscreen has its database locally so it can still work even if there are Network problems.

Now what I would like to do is have all these local databases write to a central database say every minute but only write new records to the central database. The Central Database can either be Access or SQL.

What is the best way to do this?

View 1 Replies View Related

General :: Database For Metal Market Prices To Be Used In Another Database

Jun 24, 2015

I have been working on a database for over a month now, and my boss just threw a monkey wrench in my work. I believed that the Metal Market Prices would be entered once a week in the current DB. My boss informs me today that he wants an employee to go in every morning and enter that days Price for Each Metal with respect to many different markets.

There is a total of 12 metals, and 5 markets. I need the data to be stored first by date, then by either market or metal, and lastly by which ever isn't used second (Either: date-market-metal, or date-metal-market). I think the Latter of the two methods makes the most sense. Is it possible for my current DB to lookup values from the Metals Database based on date-metal-market?

View 14 Replies View Related

Jet Database Engine Error On Non-shared Database

Jul 7, 2005

I have a problem that seems to be happening on several users' databases and is causing a big problem. None of the databases is a shared database...they are all single-user databases on stand-alone computers. I have tried looking for help within previous posts, but all seem to be related to shared databases.

I am getting an error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." The database cannot be opened, imported, repaired...nothing seems to work.

Again...these are NOT shared databases. I appreciate any help I can get. I created the database for all of the secretaries in our school district to keep up with absence data. It involves many tables, queries, forms and reports, and has generally worked well. However I am now seeing several that are getting similar errors as mentioned.

Thanks!

View 3 Replies View Related

Best Way To Import SQL Database To Local Access Database?

Dec 25, 2005

I'm new to Access and VBA, for the record. What I need to do is copy a SQL database (table structures and records) and save it as a local Access database, so that the user can query and make any changes on the local file without editting the SQL database.

Looking around, it seems like the best option would be to use the TransferDatabase method with the acImport option. Does this sound reasonable, or can someone with more experience suggest a better way to go about it? Thanks.

View 3 Replies View Related

Tables :: Create A New Database Y And Link To Database X

Aug 28, 2013

I am testing the security of my DB X on Acccess 2007. I could create a new database Y and linked to the database X. Unfortunately i could change the records on the tables. I don't want other DB that make connections to my DB to change my tables!

View 1 Replies View Related







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