Search results

I have several forms that are used to input data and run reports. Some of my forms have numerous buttons that each run a single report of one kind or another or open other forms. I would like to change all the buttons to a couple of drop down list so that I can select which report or form I want...

boblarson - you saved the day

That was exactly what I needed. I guess I should learn more about tags etc. Thank so Much for your prompt reply.

I was wondering if someone out there can take a look at a control box I have in a report which I am having difficulty getting line breaks in. I would like to separate each control with a space ([Observations], [Commendables] and [[correctiveActionRequired]) as well as a line after some text...

Hi there. I am creating a form that will (hopefully) be a control panel for conducting conference call meetings for my company. Does anyone know of a ready made form that performs this function (creating agendas and minutes etc). I am stuck figuring out how to make a subform to do this...

I should know that. Thanks for your help. That worked great!!!

Thanks for your kind response. I gave it a try. However, How would I get the 'Main Form' to do this after closing the 'New Recored Form'. I modified the code to requerry the main form as Me.Requerry.MainForm but get an error. I think my syntex is off here. Dim rs As Object Dim lngBookmark...

I was wondering if anyone knew a way to return to the same record that was just created after a requerry. When I enter a new record in my 'ENTER DATA' form, the record does not show up on the Main Form until after I requerry (which is a button on my main form). However, the 'requerry' puts my...

Thanks for your assistance. I just noticed your reply to my post. The code looks like this. Private Sub Form_Close() Forms!FormOversightCaseTracker.Requery End Sub The first form name is the above form name and the 2nd form is formoversightcasetracker2

Just got back to my computer. Thanks for your reply again. I did use the correct form name. I wasn't clear in my previous post. My code does look like what you posted, but comes up with the error msg, that's why I'm puzzled, it should work.

Thanks for your reply John Big Booty. For some reason, when I do this on closing the 2nd form, I get an error msg saying 'cannot find firstform'. Not sure why, I checked spelling etc.. But what I did was use your suggestion and simply added a 'requery' command to the first form and works fine...

I have 2 forms. One has all the fields locked so no one can change anything from inside the form. I have a button on the form that opens up an identical form but not locked so one can enter a new record. When I save and close the 2nd form, the 1st form will not show the new record until I close...

Thanks. I was thinking it would be easier to make a form first then convert it to a report when done if needed. I'll play around with it Thanks so much for your response.

I have a report that is used as a check of list of sorts for auding purposes. I would like to inlcude a 'Comment area' in the report after each section. I want to be able to type in comments in report view and have these displayed when report is printed. I tried using an unbound Label but...

Hi everyone. I know there must be an easy way to do this. I have a report that displays the records of personel which also displays a small photo on the right side of each record. I want to be able to click on the photo and enlarge it. I can create another form or report with the picture...

That worked perfectly. Boy you saved my day!! I've been playing around with this thing for 2-3 days and couldn't get it quite to work right. Thr rest of my database is coming along ok and I was getting frustrated when I got to this part and amost gave up on the idea I had. THanks a billion!!!

Thanks for the suggestion. However, this won't work in my situation. I have 17 different cities which I select from buttons on another form which then opens up this form and displays only the records for that city. Since it was filtered by the city, in the example above [BAL] I thought that...

The row source shows my selection when I created the combo box: SELECT [qryMaritimeCos].[NameofCompany], [qryMaritimeCos].[id], [qryMaritimeCos].[REC] FROM qryMaritimeCos; Also, the forms filter is set as such: [qryMaritimeCos].[REC]="BAL" [REC]is the field that is filtered when the form...

Thank You DBROWN. I did use the wizard and it should query should filter only the records in the form. When I click on the combo box, all the records are displayed from the orignal query. However, I can only select the records from the form. I would like the combo box to 'show' just the...

Anyone know about combo boxes? I have a form based upon a query from a large table. The form displays a certain number of records based upon a button I selected on another form with specific criteria of one or more fieldss. I would like to be able to show and select from the combo box just...