Search results

I know there are ways to resize checkboxes so you might search for that. I do know that if you want to resize a drawn box to a specific size, hold down the alt key while you are resizing. It lets you resize at a smaller amount of change. It works for a lot of things, like form controls and such.

Hi, I was reading this post, and I am having the same trouble. I am using a select case with option groups on a form. The first option group on the form passes a variable to the button on the form, to choose what report to open. In the report open, I am trying this code to select from the...

I would love to know if you got anywhere with this. I am actually creating a case select statement. This is because my report will come from a form with an option group. Case 1 is today, so the date field = current date Case 2 is choose a date, so the date field = form/date field then I have...

Thanks for the reply. The form works by the activities, simply because the users will look up a person (from a lookup form) enter in that day's activities, and only if the activity is one of the 5 possible, then the user has to enter in an address (because that activity is updated address). I...

I have a main form that has 3 fields. They are all locked fields, only to show the user the "person" record that they are looking at. They update to subforms on a tab. The first subform is activities (like from a mailing - received return no forwarding address, received updated address...

I would first take down all of the fields and see what you need to convert them to. By that I mean pairing them into logical tables that will have pks, and look each other up, and such. In a way that Access can deal with them. Take a look at this link on normalization for access. Design your...

I saw this post, and tried some of the recommendations to solve the same issue. I added the code to 'DoCmd.RunCommand acCmdSelectRecord', but I am still having this odd problem. I have delete code, but when I click it, the record is not really deleted. For a momentit does seem to work. I can...

Tim, thank you so much for your help. I ended up figuring it out. For some stupid reason, I put a default value on the form control of the IP field. Once I took it out, it worked fine. I'm such an idiot! The html file for my db was made by an add in. I can't seem to find where I got it...

Thank you all for your replies. I know we can figure out what is going on here. It just doesnt make any sense. I have my database documented here: Tables, relationships, forms and all. I checked everything you all suggested. It is not required, there is no 0 default ( and the field is...

My db is an inventory of printers in use at our company. It is to tell us where they are, and what maintenance is done on them over time. I have the following tables: tblIP* tblLocation* tblMaintenance tblMaintenanceType* tblMake* tblModel* tblOffice* tblPageCount tblPrinter The ones with...

p.s. I found that open args is a simple way to accomplish this

Thanks, I was able to solve it by passing the variable to the form through openargs :cool:

Let me try to explain this again, and maybe my foot won't sit in my mouth, lol. I have a global variable. I set it (gstrreportname) in the main report form. The issue is that I dont use the variable until I open a form -frmcriteria and make more choices. Then I click a button and need that...

:D I have a form set up where a user chooses a page tab. Either statistical reports or detail reports. Then they have to choose between 2 toggle buttons. Candidate or hire. So a user chooses detail, then candidate. An option group below that shows the different groupings of detail...

I have a long post that is similar to this, but I don't want to crowd this thread. I am going to post it now under this forms forum. I would appreciate it if anyone can help me. Thanks!

It is not just refreshing the chart on the access side, but in doing this, I am not technically opening the excel chart and refreshing IT. Will this do that? Refresh the data for the excel chart? I will try this out. Right now I am working on a report menu, but I will get back to this issue...

My issue is similar, so I hope you don't mind me posting here. I am having an issue with getting a frame that is null to cancel an event and give a message... Private Sub cmdOpenAJobReport_Click() On Error GoTo Err_cmdOpenAJobReport_Click Dim stLinkCriteria As String stLinkCriteria =...

chart time? :-S ;) Well, I think I am past the initial problem. I have a subreport for each category that I want to report my statistics on. One for candidates hired by office, one by department, one by application source, and so on. Now I am just working to make a chart for each category. I...

I guess bridge players do know all of the tricks :)

well, thats a good reason then, isn't it? lol it also includes sql , but yes for the same reason - access method.