I have a query, its been made from 4 table, one is Employee(all employees in my company), and other 3 are from tables Light Vehicles, Heavy Vehicles and MHE. When I run query its shom me all employees. If I put in query Is Not Null or <> in Light Vehicles for expample, its turn me back all records form Light Vehicle, but not all other records. If I dont put Is Not Null or <>"", its show me all employees. What I want is just to show me employees which have at least 1 record for Light, Heavy or Forklift, but not employees which doesnt have anything for Light, Heavy or MHE.
There was question asked on the forum a couple weeks ago about setting an event reminder that always triggered at a certain time period. Then I got to thinking about it, because I never use the timer function in Access. So I started experimenting, at first it started out with just triggering a message box. Of course the code would stop until I clicked ok. Then I set it up to run a Beep instead of the message box function. And from there I started wondering if I could get it to play an MP3.
So I used the shell function to call a specific MP3. But you can't call a non-executable - at least I couldn't at first try. I thought since the file type was associated, it would work, but it didn't. So then I called windows media player, but it doesn't autoplay when opened as a stand alone program. So then I called WinAmp, and found that when you put in a specific filename in the shell call it will automatically play that mp3. Then I thought, why not make this thing a full blown alarm clock? Ooooh, bad idea, it always plays the same song, and I certainly don't want to feel like I am in the movie Groundhog Day. Aha! I can call a playlist in winamp. Excellent, and since I have random play turned on in Winamp it plays a different song off the list when it's opened. The next problem was, what do all alarm clocks have? A snooze button. So I built a snooze button into it, and then ran into my next issue:
Winamp runs independently from Access, so closing it could be a real pain if I was to have a snooze button. Oooh, but I could put it in as an activeX control? Well, I couldn't find an easy way to do that but windows media player is easily put in as an active x control. So I did that, and whenever the form it is in gets opened it automatically plays. Rock on. Oh crap, I'm back to the specific song again in the properties of the wmp control. So then I thought hey, it's got properties, I can change them when I call the second form to be opened. I have to build a list, and select a song from it. No, I don't want to do that, that would be a pain, and be too much busy work of inputting all the songs I want to choose from. Ah, but I can take my playlist, save it as a text file, tweak it, and import the filenames to a table in the database. Give each one a unique ID number, generate a random number, open the recordset (i know, I could have used Dlookup, but I never messed with it before) where the unique ID is equal to the random number generated, write the filename to a string, and when I open up the form with the player I set that attribute in code and voila my musical alarm clock. Oh, and when I hit snooze, it regenerates the random number and plays a different song for the next time it goes off.
Wow, how pathetic. What's worse, I keep using the laptop as an alarm clock.
The other night I was playing around and deleted code from my database, which now seems to have stopped allowing me to continue to a blank form after I add a record....
It used to work, that once I pressed the save button it would then goto the same form but the form would have the same defaults as if id just opened the form.... now im getting #deleted
Is there any code I can put in the save button to get it back to the way it was before?
I have a form with 4 combo boxes. Box 1 is linked to a unique indexed field of my main table and does not allow duplicates.
Is there a way I can enter selections in the other 3 boxes and save only those 3? (these do not add data, but edit an existing row in the main table)
Experimenting, I found that if I didn't make a selection in Box 1, I could still make selections in the other 3, close (save) the form, and it would make those 3 edits in the table row belonging to the value that was in Box 1.
This is kind of what I want, except that there are many selections in Box 1, and if I select one of them and close (save) the form, I get an error message that a duplicate entry will be made?
Would a possible solution be to have Box 1 on a main form and the other 3 on a subform? If so, how do I set this up? Or is there another way to relate the other 3 boxes to Box 1, and only save the 3.
I have a Combo Box that contains two fields, the key field (StudentId) and another field (StudentName). As recommended by the Combo Box wizard, I'm hiding the key field so only the StudentName displays in the box. The wizard also allows me to save only one of those fields in my table so I chose the key field (StudentId). Problem is, I need to store both the fields in my table. How do I store the two fields from the Combo Box in my table? I'm new to Access so I don't really know VBA that well.
My form gets its data from a single table. Each field on the form is linked to a field in this table.
Yesterday, running 'Docmd.Save' by clicking on a button saved the displayed data. Today, all of the fields are being saved, bar one.
I've checked that this field is still bound to the same table field and it is. Could I have I inadvertently set some value that prevents this field being saved?
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.
Hi - I have what maybe a relatively easy problem to solve.
I have a list of locations each with a unique id. I also have another table with location details in it. There is a relationship setup between the two tables. However in the first table I have some locations that do not have a match in the second table. Therefore that field is left blank. When create a query to show information from the two tables, any records that have a blank location match field do not get shown in the output. Is there anyway to display records with blank fields?
I am a firefighter who has been tasked with creating a database to track repairs and inventory on breathing apparatus(SCBA). There are several(5) related pieces of equipment that I think should go on the same table. Three of these will have nearly identical fields. The other two will have additional field specific to them. Should I create one table including all five pieces and just leave the extras fields blank or is there a better way. Thanks.
Hello, I have a table (Projects) with original projects and amended projects. All information regarding each project is inputted in the fields for original projects. Only limited fields are inputted in amended projects;new loan amounts or a new closing date may arise infrequently for amended projects. When there is a new closing date for an amended project, and it becomes part of a query all other fields are blank for that record, How do I populate the original project data into the blank fields of an amended project. I frequently have to create queries based on the fiscal year of closingdate field and I need to know the commitmentdate (field) and other dates that are in the original projects records. I hope this is not confusing thanks in advance. :confused:
Sounds Impossible But i believe there must be a genius out there to solve this
I was wondering if there is a way to stop displaying fields on a form which contain spaces or blank values. I m using a query that takes data from a table named School
I have a table which have 5 fields. lets say: Field1, Field2, Field3, Field4, Field5
My fields from 1 to 3 have data but field4 and field5 do not have a value in it. What i wish to achieve is to show only those fields which have a value in it. Blank or field with spaces must not be displayed. Is It Possible.
I have pop up form for report selection. In my drop down i have certain reports that need to have start and end date.
I'm using this formula to show or hide start date field and end date field.
If Not [Report_Selection] = "VehiclesNotRecovered" Then StartDate.Visible = True EndDate.Visible = True
Else StartDate.Visible = False EndDate.Visible = False End If
I would like to give the user a pop message to warn him/her fill in the start and end date field when selecting reports other than VehiclesNotRecovered.
If startdate and enddate fields not filled in and they run a report - they will get an #error message.
When the Next button at the bottom of the page is clicked I want all the values of each table recorded even if there were no values put in the boxes.
For example if there is no value added to the field boxes in say half the tables I want the default value to be recorded as blank or zero so that each table has the same Autonumber associated with the other tables in the form.
:confused: I have a Text box on a Form that copies data entered into other Text boxes on the same form. Sometimes there may be the odd text box that does not have any data in it. Is there anyway that I can put in code so that the blank text boxes are not copied into the main text box i.e. Only the populated text boxes are to be copied. Thankyou for any assistance that you can provide.:eek:
ok, i have a subform and when i'm on the last field in the form and hit tab it clears the form, BUT if i go off that record and come back to it the datas there. thanx
I have a form with a field that has formula for calculation. However, I am unable to link the field to the table since the control source is my formula.How can I that field to a table?
Hi, Im trying to import a spreadsheet from Excel. I use the wizard and I get the sheet imported. The only problem is that I get additional blank fields in my table in Access. How can I make sure that this does not happen? I want to keep on importing into the same table, so these useless empty fields keep on accumulating. Any help? Thanx, Stacey
I need to create a bunch of new records that will contain some existing data and some blank fields.... what I want it to look like:
ACCOUNT | NUMBER | PERIOD | AMOUNT 4G334223 123-224-2212 1/1/2006 4G334223 123-233-2334 1/1/2006
What I want is the query to pull the account and number from the db, then add the date in automatically (not the current date, just a specified criteria to signify jan 06, feb 06,etc) and leave the amount field blank (which I will then add in the corresponding values manually).
I have a query that gets data from a table now not all fields are filled in, in this table, and the query only shows data that has all fields filled and i need it to show them all
I have a Text box on a Form that copies data entered into other Text boxes on the same form. I have used the formula =[Text2] &" "& [Combo26] etc in the main text box that I want all the information in. Sometimes there may be the odd text box that does not have any data in it. Is there anyway that I can put in code so that the blank text boxes are not copied into the main text box i.e. Only the populated text boxes are to be copied. Thankyou for any assistance that you can provide.
I have a table that tracks call-in's and tardies. Sometimes, a person will have a tardy and not a call-in and vice versa. I need to perform a calc on both the call in and the tardy fields. Is there a way to tell the database that if [Tardies] is blank (nulll), that I want it to put a zero in the field? I know this must be done by a query, but can't figure it out.
I've also tried splitting these two tables into a call-in's and a tardies table, but can't get a query that will show all tardies AND all call-in's. It will only show either all call-in's with associated tardies or vice versa, so if a person has no tardies, but does have call-in's it won't show them. What can I do? Thanks!
I have a form that displays products information. The products table has about 30 fields but not every field is used in every record. Depending on the product I would like those fields that are blank not to appear on the form and then for the form to be reorganized so there are no odd spaces.