Search results

Hi: I would like to thank the people who take the time to answer question, decipher problems and post solutions, and those who post code to help others understand Access. I have been the recipient of such help and I would like to say Thank You. Last May I undertook to develop a means, for a...

Hi: Following the suggestion on a previous thread I split my database into a FE and BE to simplify the upgrading of the clients copy. I had a chance to implement that change today and except for this error all seems to be well. The error is "Invalid Operation 3219 " and flags this line of code...

Hi: So you are thinking of setting up an empty combo box where the user is allowed to key in the beginning of a number. Then after a specific set of numbers (like 3 digits), or when the user presses enter or some such key, then populate the combo box and continue to allow the user to refine the...

Hi: Yes, eventually I can see that reducing the number of records in the combo box but initially they have to start somewhere. Since I do not know where they will start then the combo box would contain all the numbers. Thanks

Hi: I am not understanding the advantage of that? thanks

Hi: I have a table with thousands of unique numbers, each of which describes one item. I would like to design a form that the user could use to look for a specific number and then to display the information associated with that number. I was thinking of a combo box but I did not want to...

Hi Pat: Good call. I have removed the OCWxx.dll from my development system and so far all is well. Now I just need to try it at the clients site. Thanks for the thought.

Hi: After some trial and fix I split my database. Now I just have to test to ensure all is working as intended and then deploy to clients location. Just for completeness the offending reference is OWC11.DLL and I fix it with OWC10.DLL An interesting aspect to this problem is that it showed up...

Hi: Is there any constraints I need to be aware of when the client uses the front end to use the back end database. I am thinking here of the code I created to get this database working. Like, one form where I uses querydef to get the sql from a query, modifies it, and then saves the query...

Hi: Since I am from the computer days that preceded the internet I do not see this as a obstacle. Back then we used the Sneaker Net as our means of distributing electronic files. By today's standard the Sneaker Net is slow but back then it was as fast as you could run. Was extremely reliable...

Hi: I have read of splitting databases and the context was usually in a server/network environment. Just to be clear this is not the case for this client as there is no network nor is there a server environment nor is there in internet connection. Also, I am trying to see how it solves my...

Hi: So far I have gone to the clients site and updated their system. I would either create an empty database (that is all the forms, queries, reports etc without data tables) and then imported their live tables or if it is a small change I would delete the item(s) being changed and then...

Hi: I have developed an Access database and now I would like some ideas on how to update the clients version of the database. Some background. The database was developed with A2003 and is being run on A2000. The database is only used by one user on a standalone computer (not networked). Now...

Hi jdraw Thanks for the interesting link Hi John Yes ItemData may do what I want. Thanks for the link

Hi John: Yes the list box has all the items listed and when the user selects an item from the list I can retrieve the item selected. Now I would like to see the item NOT selected and then do some processing on the unselected items. I know I can do this with a record set using the same query...

Hi: On my form I have a List Box which has a query as a data source. I would like, within VBA, to get all the items in the list. Is there a way to do this or do I have to define a recordset to access the list. Note: I know how to get the item the user selected. Now I would like to see the items...

Sometimes the best part of coding is to find a really tough situation which seems to have no solution and then to solve it. I have been on this problem, off and on, for several weeks and it feels good to solve it even if the original question still remains unanswered. Thanks for trying to help...

Hi: HOORAY! HOORAY! HOORAY! I have a working solution to this problem. I figured if the filter would not work then lets try a different approach. I knew from a different post about QueryDef as a means to change a stored query. So I changed my form to use QueryDef to open my query, locate a...

Ok, but I am not hopeful since working with dates it is easier to create standard heading. You are limited by date grouping. Since I am working with item names not so easy. Actually what I have done is stripped this down to a bare minimum. I am working with one table which really has only 5...

By asking me to explain you help me check my logic. So, thanks . I will try that and let you know the results later. Updateable how? If you mean that the user cannot change the data from this form then that is ok because this is a summary for display only. Standardise the Column headings...