Search results

Hi there. I have a date picker control on my form. I have a toggle to enable & disable it. when I disable it, it's fine, it looks like any other control that is disabled. However, when I enable it, the control turns a flat white, and the control appears in the upper left hand corner of the...

:confused: Hi there. I have something strange going on. I have a file export sceification that I have set up, and I run Docmd.TransferText with a spcification that I set up. When it runs right as that line is hit, the file that I am intending on exporting to deletes. I can't explain it. I am...

Hi there, I'm trying to do a little syntax highlighting, but I'm not sure if it's possible. I'm writing a program to open up asp files, and display the text of functions one at a time. So far I am just outputting the text from the file to a large textbox, however, I don't know of any way to...

I was wondering if this has happened to anybody. I have a database that was replicated. On the tables in particular is bothering me. It appears to be missing some fields. Here's how it is. I have a form that is based on a query. That query is based on the entire contents of a table, but...

I wanted to ask any of you out there for some advice on how I am going about this. I am taking two tables, family and children, where a family can have many children. I need to create a new table identical to the family table (with all of it's fields), and just add a new column called...

Hi there, I'm having a bit of trouble. I am trying to use the dictionary object, however, when I run my code, I get an error of the object required on the red line below. Here is my code, though nothing amazing Dim dCat As Object Set dCat = CreateObject(Scripting.Dictionary) I've lloked...

Hi all! I'm trying to add together one column from four queries that are the same. They all have an id, and are all a count from another table. What I want to do now, is add up the count of the four tables. I've tried a union, but I didn't get a total of the count (Though I'm not too familar...

I have a few problems with deleteing a record from my table/form. (A2K) My form is based on a query of two tables, Order(1) and Fee(M). The Fee table has a condition where one of the feilds=1, so now, when I delete from the form, (using the wizard generated button) only the Fee record gets...

Hi all, I've searched around a little, but I haven't had any luck. I want to know if anybody has done this before. I have a project where the user would like to know if they can add fields to a table, after the development stage, ie. while it's sitting on their desktop, without my intervention...

I had a problem with lines that I drew in a report, they wouldn't grow or shrink depending on if there was data or not. Then someone (probably from this group) directed me to microsoft's page where they have a database with a bunch of solutions to different problems (the address escapes me now)...

I was wondering if there is anyway to make a group of controls on a report into an array. Why you ask? Well, I have a query that contains a main record, and two other related records, that could be the same. To clarify, I have a main table and a secondary table. The main table was within it two...

I have already searched around in this forum for the answer, but I haven't been able to find anything. I now turn to you all, and hope and pray there is an answer out there. I have a command button that I use to open a form with criteria coming from a combo box on my form. Most of the time this...

I have an address report that I am making. All would be easy in a simple universe. I am trying to get only one address per person (There is a person table, and an address table(one to many)). Now to complicate matters I want only their preffered address. There is a field called preffered...

I'm sorry, I posted this last week, but no one replied, and I really need a solution. Whenever I open a report, if there is a form that is attached or using any of the tables that this report is using, I get an error of: "The database engine could not lock table 'whatever' because it is...

I tried making my own security for a databse of mine, and I have a recurring problem. In order to keep the state of security, I use a variable to hold what security level this user has. For some odd reason every so often the variable will sort of lose this value, and in essence log a person out...

I have two tables, One holds people going to an event (Participants), and another that holds the peoples information (Individuals). I need a query that holds all of the Individuals that are not going to a particular event, where a field in the Participants table is EventID (which event they are...

I have a query which I am generating form code, and that query is the source of a Report that I have. My problem is that when the Report tries to open, I get an error like this: The database engine could not lock table 'Events' because it is already in use by another person. Now it's not only...

I saw something on here once before similar to what I'm trying to do, but it was only a mention of it in a more genral term. I'm trying to allow certain permissions through code, as I don't want to use Access' security, b/c that affects all acces databases. I have got most of the permissions...

I have a query that I'm trying to make. I two tables that I need to connect. One of the tables has a field with a 4 digit number (Table1), while the other table has a field with a 5 digit number (Table2). These two I need to join. I made a query with all of the original data from the latter...

alright, I have a bit of a problem. I've been writting a few queries of mine through VBA b/c of a wealth of criteria, however for the sake of clarity, as well as the users requesting the quesries themselves, I want to use expressions in the criteria of the query. Now, here's what I'm trying to...