Search results

The report is e-mailed to UK on an excel spreadsheet per month. I'm not that experienced with programming and was trying to make an easy process to get the table to the spreadsheet. I tried running the query, but would have to enter the perameters in twice (once to open it and once to export...

Ok, I keep playing with it, and I went into the make table and changed the field to show the 3 column. This worked (hopefully I don't have to do that every month, but I'll cross that bridge when I get there). Now my BUT is when I export that table to my excel report, it's (you guessed it)...

I have a lookup table with 3 columns: ID Indemnity Period Number of Months What I am using it for is the data entry person on the form will be given options with the column Indemnity Period. These look like fractions 1/4, 1/2, 1/3, 1/6. But for some crazy reason these fractions really mean 4...

I'm not sure, but I have had problems like that before and I was able to "Refresh" and it worked. Try creating the problem when there is nothing in the field, then go to the tool bar and click Refresh. If it shows up, I think I wrote either a VB or macro for OnLoad form, refresh the form.

I just did something like that on my database. If you are still looking for a way, let me know. This is an old post and I'm not sure if you got your answer already.

Does anyone know if there are problems with queries in Access 2000? I have a standard Select Query and I have three fields with Criteria filled in. For some reason it's not working right (I've worked long enough with queries to know how they work) For instance, my Provider has listed in the...

Sometimes my brain gets stuck on one concept and I can't break free to find the solution. I know I'm doing something wrong with my tables. Can someone turn the light on for me? (I've searched for some ideas too, but didn't see anything that helped). I have a table with Policy information which...

Thank you Thank you Thank you Thank you Thank you Thank you. And I would never have known that. So maybe my faith in myself is reassured. :)

I have a search form I got from here, and when I click the update button it brings me to Visual Basic and highlights Dim dbNm As Database FYI, the two dbo* tables are usually linked. I'm having problems with that too. I posted under Queries called "Make Table" regarding that. Thanks again.

I really have to question my abilities using Access. I have looked at past posts and see solutions, but I can never make them work. I tried using the SearchExample02.zip database, but there's a query that has a field [tblCompanies].[TradeID] Where is TradeID? I can't recreate that field. :eek...

Well, I went into the database, and found I could add a table. I thought they had it all locked up. I don't know if this is going to solve any problems, but I'll give it a go. If anyone else has any other advice regarding the issues above, that would be great. I'm sure I'll be back with more...

The main database is blocked, and no one can work off of it. It's also very complicated for this little girl, so we created a virtual table compiling the information from the main databases tables and linked it to a seperate database for me to work on. Yes, the primary keys are my problem, and...

relationship Well, I guess so. I have one linked table that has a one to many relationship with my table. When I keep it linked, the one to many is backwards. Which is why I felt this wasn't going to work for me. I do query reports from all my tables so I would think the data would be...

I am in no way an experienced database programmer. My company just bought a program that is written in Access. I'm working with Access 2000. I have my database with a linked table from the main database. This is actually coming from a query. So my problem is the linked table will not create...