Blank Fields...PLS SAVE MY LIFE
Jun 15, 2005
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.
SAVE MY LIFE....
View Replies
ADVERTISEMENT
Mar 14, 2007
...you do this:
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.
I hate you all for making me learn something. :D
View 7 Replies
View Related
Oct 19, 2006
Howdy all,
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?
Cheers Ezy
View 2 Replies
View Related
Mar 24, 2006
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.
View 2 Replies
View Related
Jul 24, 2005
Hi,
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.
Thanks,
Rod
View 7 Replies
View Related
Apr 27, 2006
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'm at my wits end here. Any suggestions?
View 5 Replies
View Related
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
Jan 19, 2006
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?
Thanks
Nick
View 4 Replies
View Related
Mar 21, 2006
In an Input form, how can I blank out certain fields such that the field data is shown, but grayed out, and other fields are shown normally?
View 1 Replies
View Related
Jul 29, 2005
Hi,
Is there a way to get blank fields to sort to the bottom rather than the top when sorting alphabetically in access?
TIA!
View 2 Replies
View Related
Oct 26, 2004
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.
Mike
View 2 Replies
View Related
Oct 28, 2005
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:
View 1 Replies
View Related
Nov 4, 2006
Hi Friends,
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.
Regards,
Darno
View 1 Replies
View Related
Apr 25, 2005
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.
Thanks,
Michael
View 3 Replies
View Related
Oct 26, 2005
I am setting up a form with a few tables in it.
I want each table to relate to the form.
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.
What is the best way to do this?
s
View 5 Replies
View Related
Jan 15, 2006
: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:
View 4 Replies
View Related
Feb 12, 2006
How do I make a form open with blank input fields?. The one I made always has a prior record displayed.
View 1 Replies
View Related
Aug 17, 2007
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
View 1 Replies
View Related
Jul 1, 2013
1. I have a Main form (based on a table) with a Subform.
2. The Subform is based on a Query
I want to save the data from the Subform (Salary Field) to my Table, I dont know if VBA will be the best option.
TABLE FIELDS:
ID*
EMPLOYEE_NOS
NAME
SALARY
MAIN FORM FIELDS:
ID*
EMPLOYEE_NOS
NAME
SUBFORM FIELDS:
EMPLOYEE_NOS
SALARY
View 2 Replies
View Related
Nov 24, 2014
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?
View 5 Replies
View Related
Sep 15, 2005
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
View 2 Replies
View Related
Jan 6, 2006
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).
View 2 Replies
View Related
May 19, 2006
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
View 3 Replies
View Related
Jan 16, 2006
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.
View 1 Replies
View Related
Sep 13, 2004
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!
KellyJo
View 1 Replies
View Related
Oct 7, 2004
Hey Guys,
This one could be a tough one.
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.
Is this possible?
Thanks!
View 5 Replies
View Related
