Search results

Hi Dev Masters, I had to call uncle on this one! I am trying to build a check constraint on a table that tracks shared resources using an EAV model. The shared resource percentage does not care how many components are included in the whole but does care that the components add up to 100...

Hello, the artomator speaking here. I am looking to solve a well known problem of template placeholders not mapping to shapes using out of the box VBA. In general I would like a user to be able to "upload" their power point file containing formatted master slides only (basically a blank...

Hello, Issue: When a query is attached to a MS Access table the AutoNumber will show the new ID increment before the record is committed. When the underlying table is in MS SQL the increment does not appear until the record is committed. This link has the best information I could find so...

Hello, RE AdventureWorks2012 Any advice on how to pass a list of sub category id's to an "IN" statement, with the caviat that the list may be null depending on the user selection from an MS Access list box. Source where I did the most homework on this: http://www.sommarskog.se/index.html...

Has anyone heard of forms crashing access when a chart object is present? When I create the form and set record source there is no problem. When I set that new form to visible It just hangs FOREVER after it sets form to visible. Please share your general insight. I am at a loss at the moment...

Hi All, I need to create a database that can track different manufacturer’s catalog. In a sense, make my own catalogue of other catalogues. Each manufacturer does things a little different but the parts being tracked are ASME certified so they function the same way. They just have different...

I have generated two queries called "qry_GetWellName_GetAPI" and "qry_GetWellProduction" that extracts all the data I need from a csv to make two tables. My issue is that I can not gather all the production data into a query formatted properly for a make table query that contains production...

I am trying to generate a simple report that can be imported to excel for analysis. Currently the database documents failure causes associated with a repair. I need a "Report" that does not duplicate the failed items in the event there is more than one cause associated with the failure. some...

I am trying out the ERD for a recipe database and can not get the relationships I should be defining on this model. I get an error when I try to have referential integrity between the recipeID in the recipe_steps table and the recipe_steps_ingredients table. Recipe ERD...

This is a question that will continue to allow me to ask questions related to another Thread titled: Combo box issues http://www.access-programmers.co.uk/forums/showthread.php?t=266782 I need a table structure that will allow me to have a repair log data entry form with 3...

I have a combo box that needs to only show approved values for any current data input but also be able to show legacy values (that were approved at one time but are no longer approved) My current issue: How can I only allow the user to select from current approved values but still be able to...

I have records that include # as part of their text string. How can I query for those records and return results containing #?. FacilityTable Facility Unit #141A Facility Unit #241A Facility #2F If I search for "unit #" on the search form control I want the query to return 2 of the...

I need to find the frequency of client's appointment activity after their last appointment in a 4 month window. My question is: (1) Is my SQL going to give me the last time a client was in the office within the 4 month window? (2) What will my SQL need to like to count frequency of...

I have cboCombo1 that cascades to cboCombo2 wich then cascades approved values to cboCascade3. The database is used by at most 3 people at one time and is located on a shared drive. I have recently got complaints that the cboCombo3 triggers an error AFTER a selection is made. (This means that...

Sorry for the late night post. I am midnight coding and need rest. After work tomorrow I will check post and keep truckin' on this project. Also sorry for code format. I had to manually type the code because the machine I am coding on is not connected to the internet. I have learned the...

Greetings, I am trying to solve a problem that seems to require a tag team effort by excel and access. My current solution resembles a broken car that is only running because of the amount of duct tape currently holding it together. I am now thinking out of the box on a way to override the...

I built a search form to experiment with the conversation on the following post mentioned at the end of my post, ( if you want to view the link just navigate through the instructions. As of now I can not post links). I too am trying to create a search form with dynamic values but seem to run...

Howdy! I am not an access/excell vba wizard but I hope to be one in the future.