Modules & VBA :: Coloring Textbox And Save It To Database?

Oct 21, 2013

here's the scenario

table1:
Name text
age numbers
sex text
date date
box1 text

now when i create form i want the "box1" change color when i triggered 1st click it turns blue then 2nd click it turns red then 3rd click white the it repeat the cycle.and after i choose a color i want to save it. along with my records.

how can i do this?

[URL]

View Replies


ADVERTISEMENT

Modules & VBA :: Save As Dialog Box - Allow User To Save Copy Of Current Database At Desired Location

Feb 12, 2014

So I have this relatively simple problem: I need to create a button that once clicked will open the Save As dialog box and allow the user to save a copy of the current database where he wishes. The filename should contain todays date in DDMM format along with some pre-set text e.g. DDMM PresetText.

I am using Access 2010.

View 2 Replies View Related

Modules & VBA :: Data Not Saving To Database When Using Save Module

Oct 27, 2014

I have a back end database that a number of people are working with using an Excel add-in that imports and edits records saved in the backend. Occasionally, when a user will update a record at first it saves to the backend but then an hour or two later, the changes made disappear. We have validated that after the user saves the changes, those changes are present in the backend of the database, but for some reason those changes disappear after a period of time.

View 7 Replies View Related

Modules & VBA :: Editing Data From Database In Textbox Taken From Subform

Jul 11, 2013

In my form I have a subform, which displays A, B, C. Then information C is displayed in textbox. User should have a possibility to modify this data in order to modify data in database.

I am able to display information C in text box based on this subform. However it is uneditable, although property of enabled is yes and locked is no.

It seems to me, that it is impossible to edit data because it is taken not directly from database but from sub form, so I make special query which takes data directly from database however I lose an event which is based on selecting proper record from subform (there is only onEnter and onExit events)

View 5 Replies View Related

Modules & VBA :: Save Access Report As PDF And Save To Folder

Jan 10, 2014

I have a few selected reports on an Access 2007 database that users can run. Is there a way for users to view the report, save as a PDF and automatically save a copy to a shared drive by modules/vba coding as an On Click event procedure?

View 4 Replies View Related

General :: Save Record Instantly When Text Entered Into Textbox In A Form

Aug 4, 2012

How do i save a record as soon as text is entered into the textbox in a form?I need it to save without moving on to the next form without having to click a button

Code:

If Me.Dirty Then Me.Dirty = False

but it doesnt seem to work

View 3 Replies View Related

Graph/Pie Chart Coloring

Jun 25, 2007

Hello :D I have an issue with Access I was hoping someone could help me on. So I have this pie chart graph with 3 sections, colored red for East, Green for West, and Blue for North. Now the problem is that sometimes, the data that I pull in doesn't have a "West" and therefor doesn't add it to the chart. This, however, throws the coloring scheme off as it assigns colors so that 1 is red, 2 is green, 3 is blue rather than East is red, West if Green, and North is Blue. I'll provide some images so it'll be easier to understand. (Clickable thumbnails)

http://img509.imageshack.us/img509/3600/beforefb5.th.jpg (http://img509.imageshack.us/my.php?image=beforefb5.jpg) http://img514.imageshack.us/img514/4678/aftermo0.th.jpg (http://img514.imageshack.us/my.php?image=aftermo0.jpg)

View 3 Replies View Related

Coloring List Box Rows

Feb 25, 2006

Is there a way to specifiy the background color of a row in a List Box based on the value of a field withing the table? For example, if a table has First_Name, Last Name, and Status (either a 1 or 0), I would like to set the background color based on the status.

View 2 Replies View Related

Coloring Certain Fields When Auditing?

Jun 16, 2014

I have a database were there is a field called Item on 2 different forms and want to color the field a dark gray color when the order is audited the actual form names are below.

Form 1 - frmProduction_Schedule_ByCPO
Form 2 - frmProduction_Schedule_BySalesOrder
Field name - Item

I was thinking about putting an on click event that would color the item field so that people knew not to mess with that order.

View 9 Replies View Related

Reports :: Formatting Report - Alternate Row Coloring

Sep 25, 2014

I am working on a report and I am having issues changing the coloring of the rows in the report. If possible, I would like the first column to be completely white with no alternating color because there is only data in one cell at the top of each grouping. So the column with "Aggregates", "Attachments", etc would have no alternating color rows below them.

In addition to this, I am having difficulty changing the alternating row color for the other columns. I'd like to use colors with more contrast. I have tried changing the color in both design and layout view, but the options for formatting row color is also greyed out, and not available for me to use. In other words, the alternate row color button on the home tab is unclickable, for lack of a better word.

View 2 Replies View Related

Reports :: Coloring Records Based On Form Combobox Selections

Apr 12, 2014

Using Access 2007. I have a form (Broker), with a combobox (cboClassifier), that I use to select 1 of 4 phrases, display the selected phrase and color the field with a color that I've assigned to each phrase.

Next, I have a report that contains all of the Broker names, addresses, etc. based on a query (qryBroker). I need the vba or whatever that colors the matching records based on the phrase selected by the combobox on the form, when the report is opened.

View 1 Replies View Related

Quick-save Database To Read-only

May 12, 2005

Does anybody know if there is a quick way of making a database read-only (so no data input OR design priviledges).

Ive had a request to send somebody a database so they can look at the data but not add/amend etc. The only thing I can think of is adding a security workgroup and assigning read only permissions. But this seems a bit long-winded and I wondered if I was missing something obvious like a 'save as - read only' option.

Any ideas.

Thanks,
Adam.

View 3 Replies View Related

Unable To Save Database Properties

Jan 4, 2008

Hi,
I have two possibly related things that have recently begun happening in nearly all of my databases. (Access 2002, Windows XP)

1. For years I have been using shortcut command lines like the following to open my databases:
"C:Program FilesMicrosoft OfficeOffice10MSACCESS.EXE" /wrkgrp d:databasesPCAMain97sys.mdw m:pcamainpublicaccess2002frontendsvikchamaster setupwheel.mdb /excl

All of my databases use the same mdw file. Up until recently this command line has always prompted me for my login and password. Now, it doesn't. Not only that, but once I'm in the database, if I go to tools-security-workgroup adminstrator, the indication is that I am NOT joined to the PCAMain97sys.mdw workgroup that I requested.INstead I remain joined to whichever workgroup I was in before; it's like hte /wkrgrp command line option now has no effect.

2. From file-database properties, I try to change the title of the database. But I get error "..unable to save the database properties". Web search shows this is probably db corruption, but... on every one of my databases???

OK, upon reading what I just wrote, it seems likely that my mdw file is corrupted....? Any other ideas?

View 4 Replies View Related

General :: Updated Database Won't Save

Feb 26, 2013

I am working on a database. I changed some of the data that was already in the database and it saved without any problems - when I reopened the database, the data was still there. But when I try to input completely new data, none of it will save (it is a database of employees and their information). So, just to make it more understandable, when I change one piece of information, it saves without any problems, but when I want to add a new employee together with their information, save it and reopen the database, it is not there.

View 4 Replies View Related

Cannot Save Database Objects When Changes Made

May 25, 2011

This has happened to me several times in the past. I make minor changes to a report and when I go to save it or close it out, it asks, "Do you want to save changes?" Of course I say yes and it just sits there, not closing out the report tab. The only way around it that I have found is to re-write the report, from scratch.

View 8 Replies View Related

Rename/Save As Function For Entire Database

Aug 24, 2006

Hi,

I am running an autocompact module in Access97 which will created a 'compacted version' of my database. I then want to rename this compacted version to the name of the original database I compacted. I cannot however find a way of doing this in code.

Basically the idea is to compact every 45 minutes or so, but what my autocompact is doing is creating a compacted version under a different name, and so compacting a copy of the database, I then want to change this compacted database name to the original name and re compact every 45 mins


Can anyone help?

View 1 Replies View Related

Forms :: How To Save Records To A Table Of Web Database

Mar 5, 2014

I'm using Access 2010 and now trying to save a selected record to another table which I have no clue where to find the "Code Builder" to put my code on after spending hours and hours, I managed to create a form, but couldn't figure out where to save this data.

All I need is to put this line
"INSERT INTO ResultTable (StudentID, CourseID, PaidID, Comments) VALUES (" & cboStudentSelect & ", " & cboCourseSelect & ", " & cboPaymentSelect & ", " & txtComments & ") WHERE StudentID = cboStudentSelect

Perhaps, the new Access 2010 doesn't use this or something new that I couldn't it.

Attached is the file.

View 2 Replies View Related

Database Closes On Save Of Query: How Do I Stop This Happening

Nov 3, 2005

I've got a database, which has been working fine for the last 6 months, it's nt spectacularly large, or complex (abotu 10mb, 15 tables, (5 of which are lookups), about 20 forms, 40 reports, and 30 or so queries).

I've tried to add a new query today, again nothing special:

all comes from one table:
column 1 - group by
column 2 - max
column 3 - if = "No"
column 4 is an expression: iif (a=1,col_a,iif(a=2,col_b,iif(a=3,col_c, .... ))) and so on for 8 col_*'s

The query creates happily enough, and is viewable.
When I try to save it, access shuts down completely with no warnings.

creating the query apart from the last column, saving it then works, but on adding the final column the database shuts down every time.

any ideas? I'm at a loss on this.

Cheers
Kev

View 2 Replies View Related

Macro - Print To Adobe PDF File And Save As Database Name

Dec 16, 2004

Using Access 2000, I have a macro to generate a report by updating various make-table queiries. I would like for the macro to print the report to an Adobe PDF file and save the file as the database name.

When I manually print the report, it gives me the opition of selecting printers and Adobe PDF is listed as a printer. After selecting the "printer", a "Save As PDF" menu pops up and currently it lists the Access Report Name. I would like to use the database name as the name of the PDF file.

In short, when I execute the "Generate Report" macro, I want the end product to be a PDF file using the database name as the PDF file name.

View 6 Replies View Related

General :: Save Database With Date And Time Stamp?

Aug 10, 2015

Code for saving access database with date and time stamp when close database as database on 11:11am on 11082015

how can i set it

View 2 Replies View Related

Possible To Get Make Table Query To Save Data In One Database

Feb 12, 2012

I am using Access 2003.I have created a Makle Table Query which gives me the invalid argument error because it makes the database balloon to over 2gb. I have two questions:

1. Is it possible to get the make table query to save data in one database until it reaches say 1.9 gb and then begin saving the rest of the data in another database?

2. Is there a wey to pause or stop a make table query to see the results and then let it run again?

View 4 Replies View Related

General :: Extract Embedded Images From Database And Save In Folder

Nov 21, 2012

Many years ago I created a database that has one embedded image for each project.

I am now redoing this db in 2010 format and I want to extract these images and save them in a folder so I can link them to the new db based on the project ID number

The table is [Project main], the unique project ID is [R&D ID#] and the image file is stored in [Item image] as an OLE object. i would like to save them to C:db images

View 1 Replies View Related

How To Save Access Database So It Hide All Tables / Forms And Reports

Mar 8, 2012

I have created a small database, and created a Main Menu (form), the main menu starts as soon as someone start my database, i have linked up all my forms & reports into this main menu. now i want to hide left panel bar that shows all the table, quires, forms & reports files (so nobody can access tables, quires, etc from that panel).

View 1 Replies View Related

Modules & VBA :: Save Word As PDF

Mar 14, 2014

I'm using the below to merge from acces to word and create a new doc. All is well.However I need to save the output file type as PDF.When I try to change the docx to PDF, it corrupts?

Dim wordApp1 As Word.Application
Dim docPath1 As String
Dim fileName1 As String
docPath1 = Application.CurrentProject.Path & "Merges"
fileName1 = docPath1 & "CreatedCover Letter.docx"
Set wordApp1 = New Word.Application
With wordApp1

[code]...

View 1 Replies View Related

Modules & VBA :: Two Fields Will Not Save

Jun 6, 2013

I have a table with lots of different fields and field types. The two memo fields will not save. I have tried Runcommand and if me.dirty. Neither seems to work.All fields are from one table and I have tried deleting the fields and repopulating them onto the form to reset defaults. The only way the two fields save is if I hit Ctrl-S.

None of the 100+ fields on this one form (yes, it is large, weird part is it fits Normalization upthrough BNSF) have the same problem. They all save fine with or without the extra code. I am using Windows 7 and Access 2010.

View 6 Replies View Related

How Can I Save My Database As A MDE Database.

Oct 2, 2007

The menu for make a MDE file is blanked out or grey’d out. The database is partly made using access 2000 then xp

Jabez

View 6 Replies View Related







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