Hey again Fancy,
I have about 20 tables with lots of data. Don't you think this would slow down my application? That thing of the global variable is something I forget to think about :-) It's a solution and probably in my eyes the only one :-)
What I wanted to do is creating a temp table. You...
Hi FancyPrairie,
Changing the recordsource through code would be an option but if you do a form filter than in the filter area you can see something as (lookup_NameField.value = "your search value". Problem is that I always close my forms and that the other forms aren't going to find the...
Hi all,
I have been struggling with a filter issue. I have several forms based on several tables. The uniqueness of all tables is that they all have a ID. I use this ID to refer to other tables, like every ohter normal program I think :-)
What I want now is that a user can do some filters on a...
Hi all,
perhaps this had been posted already, but I have a question concerning the insert Word Object. I have an mdb where there there has to be a lot of printing of different docs with a decent layout! I thought of using mail merge but then you have to use some code and Word has to open every...
Hi guys,
I Know I can(?) do it with a query but how? If I select a bunch of records in a subform and want them with a sql query insert ,the selected rows, into a new table, how in tha name of our lord jesus can i do that :-) ;-)??
thanks for the reply's
Hi all,
I have problem concerning subforms. I have a form with a subform with multiple records. What I want is that you can select one or more records in the subform and that you push a button so that the selected records are dropped in a new table. I'll use that table to create a Word doc with...
Hi Ryan,
I am afraid that's the case here. I don't know any other solution so far. Thing is that the users must see all possible disease and that they can choose as much as they want. So it's not that easy I think :-(
Regards
Badgateway
Hi all,
I’ll give it a try to explain it better.
I have the following dbs:
File_db Disease_db Disease_desc_db
File_id File_id Disease_id
Patient_id Disease_id Disease_desc
I have more tables like Disease_db and Disease_desc_db.
I managed to add a record...
Hey all,
I have a small problem using subforms. I have to convert a filmaker db to access, so far so good. What I have to accomplish is that I have to make a subform and in that subform I have a recordssource and I have to use checkboxes to add values in the access db. So when I click checkbox...
Hi,
I have quite difficult problem. I'll have to explain the way my database is built. I have one major db called files and I have a second db called errors. But there can be more errors for one file so I have to make a second db to fill up with the description of the errors.
This just a simple...
Hi guys, I have a question for you. I have an Access 97 program wich works perfect but when I convert it to XP it gives soms problems... I have a form with 2 subforms and if you double click in the subform I use something like
temp = Me.object
object is a member of the subform and also appears...
We're working with a form where you can add stuff by pushing a save button. The saved records appear immediatly in a listbox. What we wanna do is when you enter a specific name of a person that only the records appear that those person has saved and not all the other records from other users...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.