Search results

The table is irrelevant. To reference a control on another form use: Forms!YourFormName!Available

I code in both 97 and 2000 at two different jobs. I've noticed that 2000 quit putting Option Explicit as a default item on each module page. I just assumed that it wasn't necessary in 2000. Was that assumption incorrect?

I don't know what else to do. We need to be able to evaluate exactly how many people we have staffed for all 7 days of the week to decide where people are most needed when making the schedule. The overnights are in a category of their own, but I still need to be able to see how many are...

I keep running into a dead end. I am trying to make a separate field for each of the slots on my form I will want filled. So my thought was I would replace [Given Moment] with an actual value and duplicate this for each time slot needed. But I keep getting a data type mismatch whenever trying...

Are you using user level security? If so, I unfortunately don't know how to access the passwords on a form. I have had the luxury of being able to avoid user level security. I've created my own password system for information that I want to be user sensitive but for the most part, my...

The following assumes you have a subform named "SubForm" and a button named "Collapse". Clicking the button will collapse the subform and then expand it again. Remember when dealing with height that MS measures it in "twips". 1400 twips = 1 inch. 300 twips will leave the topics of the...

This is exactly what I needed (though it didn't seem that simple to me). Now I just need to try to figure out a dynamic way to use this query to display the number of people working at 34 different times, seven days a week. I'm guessing that using the runSQL string in code for each of the 238...

This is what I've done. I'd just rather see minutes and seconds as it seems less confusing. I know what it means, but not all the users are too quick. Some will see 5.25 and think it is 5 minutes and 25 seconds. Others will see 5.75 and send me an e-mail asking why it didn't display 6...

I have a query that finds the length of each call Length: DateDiff("n",[TimeIn],[TimeOut]). This works fine. However, when I try to find the average Call length for each type of call it gives me the correct answer but the formating could lead someone to believe it was incorrect. For...

I've finally got it (by the way I think I'm actually starting to understand some of this). I will post the code for creating a link to another access database, just in case someone else is ever trying to figure this out. The following will create a link named "Link" once you replace the...

I would think all you would have to do is create a table that stores the information (we'll call the field Opened) Put the following code in the startup form: Opened = Opened + 1 It will then increase by one each time the database is opened. If your database is on a network and you are...

I guess I can make my problem more specific. I'm trying to test this in a sample database and am using the following code as pulled together from help files: Dim dbs As Database, tdf As TableDef ' Return reference to current database. Set dbs = CurrentDb ' Create new TableDef...

I was looking at this last night, but I'm in over my head. I don't understand what I'm looking at. Where do I tell it which database to get the linked table from? I'm assuming its here: tdfRoyalties.Connect = _ "ODBC;DATABASE=pubs;UID=sa;PWD=;DSN=Publishers" But I don't...

This was brought up under different circumstances in a different post, and I hate to repost it because I don't want to be abusing the system. However, I need to be able to take care of this as soon as I come in tomorrow and the other post was dealing with a different issue. Each of my users...

The only way to store the number of days left (the count down) would be to build it into the table. Just make it a number field storing integers. You will still set the value of the field On Current of each new record, but be sure to condition the statement further. For instance: If...

I still must be doing something wrong. Nero, I tried following what you posted, but it seemed that was trying to detect if a field was null in the MaintenanceList table (the table that holds the names of all the linked tables). I need to tell if the linked table is null. Working with what...

When you click debug, what line of code is highlighted? If there is no debug option, check the Event properties of the check box and make sure the click event shows "[Event Procedure]".

The only way I would know to make this happen would be through the timer event. If you do not already have one, you would need to make a form that is open at all times. If you do not want anyone to see it, open it invisibly but be sure to force the user to close it before exiting the...

I am using access 97

Thank you for your replies. Unfortunately, I don't go back into work until Thursday to actually test any of the suggestions given me (here and in the other post). Pat, it all seems really inefficient to me, but I can't think of any way around it. The reason I am not working with one table is...