Search results

Hi, I have a form where a user enters value that gets entered into a table. I only want to allow the form to allow the user to only add one record in the table. Can tables be defined to allow one record entry? The problem is they enter the value and hit the enter key and the value goes blank so...

Hi, thanks for the responses but let me clarify some more. The form has 2 fields. One called type_name (list of medical specialties) and one each specialty has a check box (report_indicator) :confused:next to it. I need something like this below but it does not work. Private Sub...

currently I have a form (based on table) with specialties listed with check boxes next to each label example: cardiology, check box GI, check :confused:box etc... Currently, the user clicks the Cardiology check box and then hits the command button which runs a macro that will open the report...

I am close and you have the right idea but my form with the check boxes is only one line in design view as the list is based on a table (done this way so I can add new specialties dynamically) which is shown in the attached first screen shot. The second screen shot shows the form in design view...

ah ha, I get it now and I think this will work. I will work on it today and let you know. thanks for your assistance!

When I call the report by clicking the convert to .pdf button, it only calls one existing report. I only have one report in the database in it only displays data for the specialty based on what was checked. The send commands convert to a .pdf but I want the name tied to the check box for the...

thanks for the efforts but I guess I am not doing a good job explaining Let me create some more screen shots

The attached screen shot (zipped) may help. I click the check box in the form and then click the run to .pdf command box which calls the access report. The check box is used as a table join to the underlying query of the report to limit the results to that specialty. I hope this helps? again...

check boxes are stored in a table for filtering purposes and I do not want more than one checked at a time because I know it would be a mess unless I could create some kind of concatenate

I tried the open event for the report because there is not an unload option Me.Caption = Forms![file_name]![type] I get an error message It is looking for a macro named me.

Here is another post I had about this Hi all, I have a report the runs based on a check box that limits the data to a filtered range. I use send commands to convert to a .pdf. See below. 1. Open report for print preview Function redesign_send() On Error GoTo redesign_send_Err DoCmd.Echo...

thanks but that does not work. It is based on a different query that has a different value based on a check box that is selected to run the report and it varies each time the report runs

I have a report that when I print to .pdf is places the name stored in the cation field in the report properties. Right now caption states "name" so when I print/convert to .pdf a pop-up box appears and wants to save the file as name.pdf What I want to do is have the caption store the result...

:confused: Hi all, I have a report the runs based on a check box that limits the data to a filtered range. I use send commands to convert to a .pdf. See below. 1. Open report for print preview Function redesign_send() On Error GoTo redesign_send_Err DoCmd.Echo True, ""...

We have a user that received a new PC and is still using Access 2002 SP3 on XP (same as before) and the send object does not work on this PC but others in the office. any ideas It states send object isn't available now

I have a form (see screen shot 1 in the attached word doc) where I pick the field to create a report on. The macro uses send commands to write the access report to .pdf and then prompts me to type in the field name. See screen shot 2 in the attached word doc. The last screen shot I have included...

reply I have the same issue and write my report using a .pdf writer.

I am connecting to Oracle and can display a date correctly from a field but when I sue the select expert it does not read the dates correctly when it creates the drop down list. any ideas? thanks

Hello, I am decent with Crystal. We have a data set organized in rows in a DB. I want to pull the 2 most recent values for a member based on a filter for each instance. Example: if column a = "test1" extract 2 most recent values from column b and place in column on a report. Example: if column...

as always This forum is my life saver! Thanks to all! I actually had something like Bob's originally but I messed up the quotes (which I always do!) thanks!!!