Search results

there is a setting in in the forms properties on the other tab for pop up and one for modal. Look at both of those.

I hate to do this to you, but I would redo the aging tables... agingtypeTBL auto type - child, company agingTBL auto fktotypetable age then work on forms. Here is a link on normalization. People usually resist it, but those who follow it have 500% less confusion and more clarity in...

Private Sub Image115_Click() Dim sid As String sid = Forms!mainscreen![sid#] DoCmd.OpenQuery "UpdateBasicData" docmd.refresh (query)

it wouldnt be pretty, but sure - make the field to be the link to the word doc a hyper link. If you are on a network you will need the full path to the document ie \\servername\folder1\folder2\/documentname.doc Thats what it will look like in the field too...

I had a thought, so I figured I would post it. There is probably a much easier way. My thought would be to run a command that opens the excel spreadsheet, and then runs the delete command directly to it - careful and make a backup to test on till you are sure it is running right. It would...

I don't know if this will help, but I only see this being done in a query. Access tables allow for a lookup to another table. You can either have the table be the name and surname, and use a query to create the number column with a formula, or I am not sure how you would "create" it in the...

I don't see why not. If you are just looking at suppressing labels when there is no data in the column, there are a couple of ways to do that. 1 is to put the field and label together in a text box in a formula that would only show both if there is data. Problem is you get the lable in the...

in the report design, try changing the combo box to a text box. Right-click and choose change to - text box. Then see if it shows.

I see what you are saying. How about this. Is there a way to prevent the user from changing from the current record on the main form if fields are not chosen on the subform? That way, I am not saying don't save, I am saying don't move, go to that field that needs a choice. The move that the...

I am working on stream lining reports for my application, so that I don't have a huge maze of menus. I am open to any ideas of how to best set this up. Right now I have a report menu with about 8 command buttons. Some take them to a criteria form for that report, others straight to the report...

:( I'm sorry, but that wasn't exactly the response that I was hoping for. Should I repost this question new? I was thnking that the purpose of the posts is to stick to related, but if this is a dead issue in this post, I would be happy to reword my question in the hopes of getting some...

I have to say, I really enjoyed reading this post. You two made me laugh. I am planning to do the same sort of thing. I am working on stream lining reports for my application, so that I don't have a huge maze of menus. I will have to have a report menu with one button for detailed reports...

I have an application that enters candidates in, who apply for a job. I found that I can enter a candidate in, and if I dont enter at least an address type or phone type ( giving that candidate an address record, albiet a blank one (just a type of address) and a phone record) then the candidate...

its sounds like it is up to your design. You can put them side to side. You just have to make it fit. If you can post just the forms, so that I can play with the design, please do so. Just make sure all of the fields that you need on the main form and sub forms are on them, and we will work...

I don't know that you can get ##:## as a format, as Access will want to read that as 12 / 24 and will only want to go that high. I would suggest maybe trying a decimal. Try that from the beginning. Then you could trick the format on the report. How? IIF([field]=[field],left([field],2)&":"&...

thank you for responding. I do not see the 2 form fields for start and end date is not the problem at this point. I understand that once I have a report based on a query, I can put a criteria in the corresponding query field for [form][formname][formfield] and then have that field on the form...

I could be wrong, but it sounds like you have a parameter being asked from several places. I would either make them all the same (3 charts, 3 parameters, set them to a form field) or pass one parameter through the next. This would mean that you find which is the first parameter to be asked...

I have a database, and I am looking to add a somewhat master statistical report. The database is for candidates that apply at my work, for a job. The statistical report will be for counting who we have hired. The factors are what department they were hired to, what office, and what candidate...

have the application and I am just working on some improvements for the front end. I have about 30 mail merge letters (and 2 merge envelopes) set up for use with the records in this database. I am working on setting up a menu with a button for each of the letters ( 2 menus, each with about 15...

take a look at subforms. You can make the main form bound to the table ( through its control source) to the table that has the information for the combo. Then the subform will link based on that combo and the subforms field which matches it. You will have to do some digging in help to...