Search results

I actually started creating just a single patrol table in the beginning, but wasn't sure, so I ditched the idea... now that I see that was the right way to proceed, should I make the type of patrols as one field as drop down or each its own field as a check box, same question for the month. I...

I have attempted to create a new database and am having a few problems... I am curious to know the best way to set up the following database: used to schedule certain types of patrols on a specific pipeline section during specific months for a specific person. Here is basically how I am set...

I did not find an answer... although I did finally get it to work. I ended up recreating the main form and then added the subforms back in and it worked. I have no idea what happened the first time that it did not work correctly. Good luck!!

Allow edits is currently set to yes... still no luck.

The forms are also linked in which I have defined my own criteria to link (which is the same linkage in the tables).

Each (what I'll call) sub table is linked to the main table, but they are not linked to one another.

The data entry property of the form is set to no, still no luck.

I have actually already attempted to go out of the form and then back in and the information still isn't showing up... Here is something else I have noticed...after inputting, the information shows in the correct tables, it also shows in the subforms that are standing alone... it is just not...

I have created a form from a "main information table" and am attempting to create subforms under it from several other tables. I get the subforms created and can input the information and it shows up in all the correct tables (which is what I want)... here's where the problems comes in. If I...

I do have it set the way you listed and no luck... I did try something different and it seems to be working better now. Instead of pulling the info from the table where the the auto look up column resides, I have written the query to pull the last name from the employee table and so far so...

I have a database with multiple tables. In one of the tables I have a column to auto look up the employees last name to an employee table (these tables are also linked). I have it look up to show me the last name with a primary key set (which is hidden) on their employee number. All works...

Jack, thanks for the help... this fixed my problem.

Here's the way I added the memo field: Opened the table in design view, added the Field Name & then changed the field type to Memo from the drop down list. I then go to view and attempt to type in the info & it is cut off after 255 characters. How do I drag the memo field from the list?

I'm not sure I understand the reply... where's the onactivate event?... how do I add an unbound image control?

I have created a column in my table and set the data type to a hyperlink that links to a folder that holds photos (jpg). I am able to click on this link and get to the picture that resides in that folder. When I create a report I am getting the link address and would rather see the picture...

I am attempting to add text in a table that is too lengthly for a text field... I have changed the data type to memo and am still having my text cut off after 255 characters. I notice that memo is available to 65,000+ characters but mentions something about DOA. Can someone provide help with...