Search results

Hello, I have a report that has an Excel and PDF icons and when they are clicked, gives users a prompt to save either in Excel or PDF format. My question is.....would be it possible to override the saving part? Can you export it into Excel first then save? Users just wanna view the file in...

Thank you Bob it gives me exactly what I wanted.

Hi, I've noticed that when a form is opened, the cursor is always focused on the first field. I would like to have a safety measure in check, which prevents form hitting the "ESC" button and accidently deletes what's in the textbox. is there any way to set it so that when the form loads...

Hmm let me think about this further, but thanks Bob. Yes the people who are simply viewing the database will be using forms alot.

Hi, Would it be possible to have a button on a form that simply takes users to the previous form that was opened? Users now have the option to look at all the tabs that were opened at the top, but if they open too many of them, sometimes it's harder to go back to a specific form. Am I...

Thank you so much. It works like charm

Thank you very much

Could someone help me on this please?

Hello, I have been playing around with it but got nowhere with it. Attached is a test copy of what I'm trying to do. In the form, if you make a selection from the dropdown combo called "client area", then ideally the category combo box should show you a list values LIMITED to that...

Hi, yes they are all bound combo boxes and yes they are combo boxes by design. The requery as I just mentioned works now, but the 2nd and the 3rd combo box are still giving me info like this based on the 1st combo box selection 1 1 1 1 1 1 1 1 1 1 or 3 3 3

Hi, thanks for posting back. The requery part works. The dropdown selection problem persists. It seems that it's referring to the ID instead of the text description, and the same numbers repeat still even when I'm using SELECT DISTINCT. (by text description I mean the actual text...

Hello, I have 3 individual tables that feed into one junction table in the middle. On the data entry form, there are three dropdown combo boxes. The 1st combo box is client area, which can be 3 areas. The 2nd combo box is category, and the 3rd initiative. I have the recordsource of the...

Hi, thanks for posting back. I just tried it now, but when I clicked on the toggle button, there was an error saying sub or function not defined. Error message is: Private Sub Toggle21_AfterUpdate() If Me.Toggle21 = True Then AlternativeSubform Else defaultsubform End If End...

Hello, Could someone point me in the right direction? I have a form that has 2 dropdown combo boxes. Users would like to select from the filtered recordset from the combo box based on the previous combo box selection. I have a test copy set up, but it's partially working. As you can...

Hello, I have this query that tells users whether or not a particular issue is late or not. The code is this and it's working now: IIf(DateDiff("d",[Issue_Master]![Due_Date],Date())>0,"Late by " & DateDiff("d",[Issue_master]![Due_Date],Date()),"Due in " &...

Hello, I have a textbox setup on the form which allows rich text formatting. So the richtext formatting is to "allowed" in the form property window as well as in the table. The problem is.....for texts that have a strikethrough line, the line is not shown on the form. How do I get around...

Hello, I am having difficulty copying and pasting a column of date data from Excel into Access. In excel, I have changed the datatype of the column into Date(short date format) and I did the same thing in Access. When I copy the column from excel to access, I get a warning saying invalid...

Hello, I have a memo field on a form. When a use wants to paste a lot of stuff in there, the form seems to be cutting @ 255, which is not acceptable. Is this supposed to happen? Any comment? many thanks

Hello, I have a junction table that contains a hyperlinked field that looks up values from a master table that contains all the hyperlinked records. Somehow if I change the datatype of the junction table record that looks up value from the master table into hyperlink, it's no longer drawing...

Please see the attached database file. It's an example of the problem I'm having. As you can see, the relationship is one to many. Under query, you will see the total chair counts. We get 20 under lab because it's 5 + 5 + 7+ 3. The problem is that I would like to count 5 only once since it's...