I'm new at access but getting the swing of it. It is a pretty cool toy.
I have a table that I am adding various columns of data. Once added I move the columns to where I want them to be. I am hitting the little save disk on the top toolbar but when I reopen the file the columns are not where I placed them. I'm not sure why this is happening. Any thoughts?
For some reason when I change the order around of the columns in a split form or subform 90% of the time it wont save (right click save, file save, etc..) and have to constantly redo it until it finally works. Am I missing something obvious as to why this is happening?
I was able to use the UNION ALL qry. But, when I have another file (like original2) that does NOT have all the columns listed in the UNION ALL qry, I get a Parameter value box asking for the missing columns when I run the qry.
original 2IDDateGroupChristianJohnny18/6/2013A212528/6/2013B2338/6/2013C2248/6/2013D22
The UNION ALL qry includes all the possible resources ( includes all the possible column fields Christan, Johnny, and Steve).
When I run the UNION ALL qry with the original2 file, An "Enter Parameter Value" box is displayed with the mssing column name "Steve".
Is there a way to Map the original2 table into a working table with all the columns, or use VBA code to construct the UNION ALL qry to only include the existing columns? My data has variable columns and I'm trying to avoid the parameter popups.
I have a MS ACCESS 2010 database with a data table which i am trying to create a query from. I have 6 columns of data( one with an ID Field and 5 Name Fields). Below i have made examples of how it first appears as a simple query and the second will show you what i would like it to look like.
What the simple query looks like: [URL] ...
Second what I want the query to look like: [URL] ....
Currently I'm building tables and forms. My first table (called Clients) lists the details of fictional clients. My second table is for invoices.
In my invoices table, I wish to link the column for client reference (note: stored in the Clients table) to the column that precedes it. This column will list the clients’ names and is selected from a drop down list that is linked to the Clients table.
What I want to do (if its possible) is to have the respective client ref. automatically show up in the next cell once I've selected the client to whom the invoice relates?
Am I making sense? Is that possible? If so, how do I do it?
Secondly, how do I do a sum of selected columns for my “totals” column? Basically, I want to add the figures found in several cells that precede it?
I'm affraid my confusing topic title is an indicator of how confused I am by this. I can't even understand the variables well enough to fully utilize Access Help or the Search function here...
What I have is a database hat has column headers that look something like this: Customer_Name, Order_Date, Qty_Ord, Unit_Price, Total_Price
What I'm trying to get is a query output that will have
Customer_Name, Total Orders (in Dollars) for January, Total Orders (in Dollars) for February, Total Orders (in Dollars) for March, etc.
I've been able to set it up to SUM for one month, but not multiples.
I know I'm totally lame (for proof read any of my previous posts) but you guys totally bailed me out the other time I asked a lame question.
thought I was ok at access, obvously not. Think 'briefcase' has messed with my db a bit so started using a backup with ext .BAK. Want to save whole db as another name with ordinary extension. Will only let me SAVEAS on bits of db?
Sorry, I know this is a bit simple but that's about right for me.
Hi all, when the users are saving the form, i want to make sure they have filled in certain fields. On previous forms my code has worked, but for some reason on this form it won't, i usually put:
If tankID = "" Then MsgBox ("Please Enter the Tank ID") tankID.SetFocus End If
Can anyone explain why it may not be working, thank you
I have a table which brings together a number of bits of info from other tables.
Part of the form is acting weird; The user selects an 'applicant', and a 'class'. On the form these are both combo boxes, with info coming from two tables.
Some properties of the two fields: SELECT Classes.ClassCode, Classes.ClassName FROM Classes; Bound Column = 1
SELECT Applicants.ApplicantCode, Applicants.ApplicantName FROM Applicants; Bound Column = 1
Now, I want it to store the ID's of both (rather than the name). Both of these combos have the same properties; however when I look at the table, the applicants ID is being stored, but the class NAME is being stored in its field instead of ID>
Hope someone out there can help. I have a form (frmNewExceptionRepot) where the record source is a table (tblExceptionReport) there are a fair few controls on the form from this table and some controls that are based on queries etc
I have a cmd button - that takes the value of text boxes from a subform on this form and saves them to tblExceptionReport It also saves the record in general
This all works fine, however I am having a problem saving the value of a list box on the form (not subform) List156 to the table tblExceptionReport. The record source of the list box is a query that only ever produces one result, and its always the first row that needs to be updated to the table.
The data is displayed correctly when the form is loaded, but the value will only be saved if you click on the list box before the record is saved. I understand the theory behind this, as its a listbox an item need to be selected. However is there a way to tell it to select the first row of this list box as the value? I have tried various ways around this, but just can't figure it out. Should I be using a text box instread? I had thought about basing the form on a query that contains all the information, so this list box can actually be a text box, but then it makes the recordset not updateable...which means lots more code on the save - if this is the only way round then fair enough! Any ideas or help much appreciated!
I have highlighted in red the code currently in use to try and do this. (which works if you click on the list box before running the code.:confused:
Private Sub Command242_Click() 'save record DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 'Save the current dates and informaiton to the new record DoCmd.RunSQL "Update tblExceptionReports set CurrentVRF = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastVRF], CurrentLandingSlot = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastLandingSlot], CurrentPlanComplete = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastPlanComplete], CurrentReqtsSolWShop = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastReqSolWS]," & _ "CurrentAlignmentReview = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastAlignment], CurrentDSBBidPictureEvent = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastDSBBigPic], CurrentCostBenefitEvent = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastCostBenefitWShop], CurrentDSBDetailedEvent = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastDSBDetail]," & _ "CurrentITExecutiveReview = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastExecRev], CurrentITSupplierPropIssued = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastITSuppPropIss], CurrentSellByDate = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastSellByDate], CurrentViabilityReport = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastViabilityReport]," & _ "CurrentProgramBoard = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![LastProgramBoard], CurrentProposedImplementation = [Forms]![frmNEWExceptionReport]![frmExceptionReportStaticData]![Proposed_Implementatation_Date], OverallRAG = [Forms]![frmNEWExceptionReport]![List156], CurrentSpendBudget = [Forms]![frmNEWExceptionReport]![List240]" & _ "WHERE tblExceptionReports.ExceptionReportID = [forms]![frmNEWExceptionReport]![ExceptionReportID]"
I'm trying to create a database for a taxi-type service that runs on thursday, friday and saturday nights. My question is: Is there a way to save the database at the end of the night separate from the previous nights, and so that the database is empty for the next night, but reports can be viewed for all of the nights combined?
I have a annoying problem. Since yesterday whenever i make changes to anything in my database, it doesn't ask me if i want to save the changes, it just does it automatically. It is annoying, as sometimes i am testing things, say on a query and if it doesn't work, i just go out of it and don't save the changes and have my original version.
I have another Access database and this works fine, with the pop up message asking if i want to save the changes or not.
Can anyone help, or point me in the right direction, thanks.
I seem to be having problems saving my database files (.MDB) as .MDE files.
I have a database that only contains data (tables).
A second database is used as the interface to this data (it contains forms, reports, and uses linked tables to the data database).
This secong database file is then copied and used my a few users, so that everyone is accessing the same set of data.
I am trying to save the second database as an .MDE file, but under the Tools, Database Utilities option... 'save Database as an MDE' is never highlighted as a viable option. Is there some trick (or conditions) to enable this option?
I am basically doing this so that I can distribute the MDE version of the interface so that users will have limited / no access to be able to modify the code (or get into the table?).
Thank you for any advice or directions you may be able to pass on.
Have a bit of an odd problem with the DB im using at work. I have 1 DB on a shared drive that is accessed by 4 of us from our desktop PC's (password protected via 1 password that we all use - no separate logins).
The problem comes that we make changes to the data, exit via an exit button that uses a save all macro (that all works fine), however when we go back into to DB there are some times that the changes made have been lost and the data has reverted back to the previous version. There doesn't seem to be any specific pattern to this, it happens at random times and to random people.
Does anyone know what may be causing this, or anyway that i can prevent it happening?
Hi, I have been tasked to create a database that will be accessed through a dial-up connection to our server. What I want to know is which is faster 1 Using a seperate table for dropdowns or 2 Using the lookup facility of a table. cheers
I have a main form where the user can click on a button that opens another form. In this form, the user can make selections from one listbox and they are copied to another listbox. How can I save the contents of the listbox into a field that is part of the record on the main form? Can this be done? I have a listbox on the main form where the selected items will be displayed and each record of the main form will have different values for the listbox.
I have created Several Forms but I am not able to save any new records in them. When I click the add new button the records are added alright. but when I exit the form and reopen it all the new data added to the form is lost. I even tried the save button but that doesnt help. anyone has ideas what happening here..
I have a form in which an individual has to input a date then choose a category. This is for keeping an individual's time. I want the date that user user first inputs to be the default date that is shown automatically unles the user changes the date, at which time, I want the new date to be the default. Can anyone tell me how I could do this?
I have a form in which a user uses multiple combo boxes to choose certain items. each item in the combo box has a key attached to it in the table that the form was created from. I would like to save the appropriate key on my form next to the combo box. If this is possible, how do I go about doing this?
I just spent all day redesigning a form and putting in check boxes from the tool box, but when I saved the whole thing and tested it by clicking in the check boxes to put the check marks in the boxes and then clicked save, it did not save the check marks! AARGH! When I went back to the form all the check boxes were empty. Why won't it save the check marks? Please help. Thanks.
I've put a button on a form (lets say form 1), that when clicked opens up form 2.
Both forms are connected to ONE table each.
There is a sub table on form 2 that displays records with the same Id as on form 2.
The Problem is when I open The table that feeds the subtable. If I change the A to Z ordering on this table, whenever I close form 2 (not from design view, from user view), it asks me whether I want to save the changes to the design of the table feeding the sub table (the subtable that is on form 2, that is)?
When form 2 is closed there are calculations that are made and data is updated on form 1. I don't know if this is part of the problem? or perhaps I have set up the subtable incorrectly?
I have a form "release_details" having fields date, version, cksum ,comments,labels, and is link to a table, it has a button "mai"l ,on clicking this button a new form is open which has a button "send mail" on clicking this a mail is sent and pops a message "mail sent".I need when "send mail" is click it should also save the fields of form "release_details" to the table.
I have a form that shows entries based on other parameter values they are changing when new searches are used. I created another form that shows the entries I would like to save and they are bound to the other form. I can view the data in the second form one by one based on what happened in the previous form but when I close the first form the data goes away in the second and leaves me with a #Name?. I am trying to come up with a way to save every different entry and create continuous records on what was entered. Is there a way to have the text boxes be bound but still save the record and just create a new record for the next entry? I tried the save record option in the records menu but when I close out it is gone. Thanks. Mitch
Hello, I'm new to this whole microsoft access program, so I'm learning from scratch. My question is I can't figure out how to save the database, so that I can go back into it later. This is a tutorial that I'm working off of in my online class, so once I exit out and go back in, all the info that I inputed is gone.