Search results

ok, here's a radical thought. What if you defined a table with each element as a number (integer) entry. Enter a number 1 as the field entry for each element. Do not set an autonumber or key. Then built a query from the table. Then link each button to each specific field in the query, and on...

I think you could solve this problem by linking the two tables together. You need to define a foreign key for the services ID in the personnel table. You would then have a many to one link between the two tables and as you add records to the personnel table the foreign key would link the...

I need a way to add mulitple fields from a client search into a project form. For example, I have a project form which is running from a multi-table query. On this form, I have a search button which pulls a second continuous form to search for clients. This form could be either table or...

I have a client issue with a product built in 2007 and applied to the 2007 runtime. The client has Windows XP and is running windows 2003. I suspect there is a macro security issue that is preventing the application from running, however I need to test in version 2003. When I click on the...

thanks. I see a macro link doesn't work for this either. Know any good alternatives to runtime?

Yes, I saw that thanks. My only issue now is determining what goes in the boxes. Some of my documentation does not match the 2007 version of Runtime, and examples are nonexistant. I hate to keep bugging you, but you seem to know this stuff pretty well. I have...

ok, I'm going to risk sounding really stupid here, but here goes... I assume you are manually placing this in the end-user's computer registry.... and NOT, as I was inquiring about, adding it to the runtime package and sign - in an effort to have this automatically installed on the end-users...

Davida- You said that you had success with the Packaging Wizard automatically adding a trusted location for the application....?? I have not been able to make that happen.... I've been using accde in the packaging. Did you need to add the key into the "Additional Registry Keys" section on...

I am attempting to put a button for Linked Table Manager into either a custom ribbon or Office Menu, then build the application in runtime. In building the XML UI ribbon script, I noticed a spelling error(either intentional or not) in the file name "DatabaseLinedTableManager" as reported in...

I am having a problem with embedding a bmp file as OLE. It has been working fine, but a few weeks ago I downloaded SP3 for Office 2007 and now have a problem. At first I was getting the error 502750, OLE Object failed, reinstall. I followed the advise noted by Sinfathisar and was able to...

Have same problem. What did you use to run regedit? When I click on the file it asks me for a file type selection, but cannot file anything in the list that looks applicable and web is no help. Did you run from command prompt? thanks

to simply!!!!! Works great Thank! :)

I have 3 combo boxes with selected reports that I want to display based on the types of filter variables selected. I am attempting to control which list displays based on the selection in an option group "ReviewLevel." Here is the code I am attempting to run. It seems to not recognize the...

Ok, I got it.... The syntax needed to be..... Between [forms]![frm_Reports].[StartDate] And [forms]![frm_Reports].[EndDate] . not ! before the field Thanks for the assist. I like this much better and should solve my issue. (I hope)

ok, I see an immediate error... StartDate vs StartingDate and EndDate vs EndingDate. I fixed that, but still the same issue remains

ok, I'm not 100% following, as I have not approached it from that direction before, but here goes.... In my reports page (frm_Reports) I added two unbound text boxes (StartingDate and EndingDate), and specified short date type. I then removed the parameter in the query running the report...

I have a query with a "Between" statement to filter the data by a specific date range. This runs fine. I then built a report and pull data into the report from the query. When I run the report I get the date range between statement to answer as I expect. So far, so good. However, when I...

I agree. MS opted out of user level security in 2007 instead relying on server level security. I have some experience of what can go wrong in converting 2003 to 2007, so let me pass that on.... You should be able to run 2003 in Access 2007 without converting it, once the security is...

I actually had the same issue last fall, multiple crashes and the compact and repair would completely wipe out my tables. Thankfully I had backups. I was able to work with Micrsoft on the issue and came up with two possible solutions .... I my case, I first imported all my tables, queries...

Is anyone aware of a bug in 2007 which is related to forcing a user to answer a date range twice when pulling a report with a chart. I have a query that has a between date range defined. It works fine. I then built a report which includes a chart. Which pulls fine as long as the date range...