Search results

KeithIT, thanks again! Yes, I do have a field (ClientID) in the parent form set up to display the field from the table. this same field (ClientID) is also set up in the child form. Whatever ClientID that is selected in the parent form, that same ClientID appears in the child form. By the way...

KeithIT, thank you very much for your help. My form is actually based on a table. What happens is that I have a form that contains client ID and client names as a drop-down, these come from one table, let's call it Table1. There's also a sub-form that is linked to the main form through the...

Hi, I have a table with fields - Client ID and Funding Source. These fields are already filled in. I created a form where users can enter some additional information for each Client ID. What I'm trying to do is when that form is opened and Client ID is selected, I need the input box that holds...

Thank you!!

Hello, I have two fields - beginning income and ending income. I'd like to calculate percentages for those two fields. In other words, if income increased for example, I need to know by what percent. Does anyone know how this can be done? Thank in advance for any help.

I just FTP'd a new db to the server, and still getting that read-only error. And the permissions are set as well... is there anything else I could do? Thanks.

Thanks Ken. I doubt it, the server should have enough space on it, and the database is pretty small, just 140KB. any other ideas? Thanks!

Thanks. But "read only" is already unchecked. I ftp'd the database to our sever and it's there. But for some reason I get the read-only error. any suggestions?

I'm trying to create an online form that is connected to an Access Database. The data from the form is supposed to be collected into the database, however when I press submit, I get an error message that says- [ODBC Microsoft Access Driver] Cannot update. Database or object is read-only...

Hello, I have multiple queries that I need to display in one report, I was wondering how I can do that? Also, I need to total some numbers from those separate queries - how can I connect the data from several queries, so that I could total some of the fields? Thanks in advance.

Or can't I just do this: Date Left - Date Entered Wouldn't this give me the number of days in between?

Thanks for your help. I did not find DateDiff in the help files, although I did see it as one of the functions available. I'm not familiar with this function, but I tried to build this expression for my field: Expr1: DateDiff ([Date Entered], [Date Left]) , but of course this syntax didn't...

Hello, I have two fields, one contains start date, the other contains end date. Is there a way to construct a third field that would display the number of days between those two fields? For example, start date is 01/04/2004, end date is 01/14/2004, I would need the third field to count and...

I don't think it has to look exactly like that, as long as it accomplishes the same purpose and all the numbers and totals are sort of aligned and easy to read across. The way we have this report now is that it prints out on many pages and is hard to read, whereas with an Excel spreadsheet the...

Cosmos 75, Thank you. What you created is similar to what we already have, but my boss wants me to create something different, something like the attached spreadsheet, but in Access. If you look at the spreadsheet, it shows everybody's names and a lot of different totals and subtotals. any...

Cosmos 75, Thank you very much. My queries are pretty much the same, but I don't think I can just group them all in one query, because I created them step by step, through other queries. I think I created 2 queries that give me the last one, and so forth for each one of the five final...

Hello, I have 5 separate queries that contain similar info for 5 separate categories. I need to create one report that contains data from all those queries. Is there a way I could do that? I would need the data to go across, from left to right, and then have totals calculated at the end last...

Hello, I have 5 separate queries that contain similar info for 5 separate categories. I need to create one report that contains data from all those queries. Is there a way I could do that? I would need the data to go across, from left to right, and then have totals calculated at the end last...

I cannot open a database that I've been using for a long time now. I get this error message: "Unrecognized Database Format". Even though it always worked fine before and it is an .mdb file. Does anyone know what is the problem and how can I restore the database??? Any help would be greatly...

Thank you so much Fizzio! It worked!