Search results

Hi Lagbolt, Thanks - I found that out after I posted it - and I really didn't mention in my first post that I want the combo box to be dynamic from a table and not a hard coded list. I've found postings thru google, but not a good example of how it looks and how the table is connected to it...

I have one combo box that I allow a user to select a value and I create a report based on this value. I don't like to have a form displayed with just a combo box, so I was wondering, does Access 2007 limited ribbon capability support a combo box in the ribbon? Thanks to anyone who answers...

Usually combo boxes are based on queries and in order to "make a combo box grow" it would be to requery it and if any new rows are there, they would be retrieved by the query. So, the combo box in essence would grow - actually it would contain more rows. I've never used a lookup table with it...

Hi - I agree - something else is going on...

I tried that too, but it didn't stop the code from continuing to process and display another report and form. I created menu selections to view the reports instead - that's a way-around and I didn't solve my problem, but no more time to spend on it. Thank you for your reponse, I appreciate it.

ADOX isn't a website, its part of Microsoft Access, but you have to include the library in the tools, references to use it. I believe it is Microsoft ActiveX Data Objects library I haven't done this for about 6 years, but if you go to the vba side of access and click help. I just clicked...

Hi, I don't have my reference books with me right now, but google on ADOX; it has what you need to create a table in Access. This is very similar to ADODB except it is geared towards creating tables, indexes, etc in VBA. You'll also have to include the ADOX in your tools, references. Also...

Hi all, I am calling a report from a form using the following VBA code: docmd.OpenReport "rpt-05",acViewPreview,,,, "DownloadProcess" In my report, I set Pop Up to No, and Modal to Yes. The report is created and displayed, but my code keeps on truckin... I thought that the modal would...

If I don't get any suggestions here, I thought I'd tell you all how I got around this in case anyone wants to link documentation to their apps. It might not be the best way, but it works rather nicely. 1. Created my help documents in Word and saved them in PDF format - I didn't want Word to...

Hi all, Is is possible to create a hyperlink on a custom ribbon to open a pdf document? I want to link to some documentation for the database. I know that I can create a hyperlink in a table and I could have the users open a form that would allow them to select different hyperlinks and read...

Yes, I agree that the F1 should be optional. I'll see if I can find some help on providing some of my own documentation to the F1 key. If I remember it correctly, its kinda involved.

Thank you very much! I can see by the selections there and trying each of them out, that I can't see my supertip without seeing the Press F1 for more help.

Hello all, On my ribbon when I hover over a button, the supertip that I entered is displayed, and then the message "Press F1 for more help" is displayed below it. I would like to eliminate that message AND even disable the F1 key entirely. Is there an easy way to do either of these things...

Hello all, I would like to change the path of a stored import (Excel) via VBA rather than displaying the Manage Data Tasks window to my end-users. I'd like to display a popup allowing them to search for the correct folder, and then I would insert the selected string. So far I found...

Thanks Big Pat for responding, And, yes I do have Access 2007 ... One other thing that I forgot to mention is that the users that will use data entry in SharePoint are remote in other offices throughout the state, so I know I have to find a different way for them to enter data because Access...

Hi all, I have an Access 2007 database, FE on desktop, BE on a local server. I'd like to have a simple data entry form (with a few look-up lists from the database) in Sharepoint that would allow a user (who doesn't use the actual database) to insert a record- something like a help desk ticket...

That's perfect! A picture is worth a thousand words!

You can create an alternate unique index on the table. You can combine the two fields and then make sure that you indicate that it is unique. This will prevent a duplicate of the two fields from being entered. I'm running to catch my bus home now, but if you respond that you dont' know how...

Yes, I tried that and it didn't work, but I just found an answer on another site: DELETE FROM tableA WHERE tableA.ID IN (SELECT DISTINCT ID FROM tableB) This works great... I forgot about the inbedded select statement for the matches... Thanks for reading!:D

Hi all, I totally give up on this one - but I guess not totally. I could do this with a recordset in VBA, but I'd really like to accomplish this via stored query. I have one table that consists of one column which is a Long Int field and I store a key value in it - call it tblTemp. This...