Recent content by okerix

Awesome stuff NBVC! Just learned a whole lot about Access with that one. You rock!

Hello, I am trying to work through the logic of how to do this in Excel. I have a spreadsheet with about 20,000 rows in it. It's full of information about people's visits and the referrals from that visit. There are three main id columns the person_id, form_id(visit's indicated by form_id so one...

Hey Bob, I checked her references and none were missing and I dont use DAO but I do use ActiveX Data Objects 6.0 reference and I removed and readded that and BOOM it worked! I even shut down the DB mutliple times and it continued to work. You were spot on with the diagnosis of a corrupt...

Okay got an update. It is definitely an issue with just the computer. I can use either front end file which work perfect on my computer and on other people’s computers and they fail on hers. Another thing I found out is that after I delete the field and readd it it will work until we close the...

the_net - You might be right about that. We have two version of the front end file one for each manager(theme differences and differences in whats defaulted in). So maybe I through the other managers on there computer and try that. Maybe it is corruption and I need to just rebuild that managers...

Hello, I am having a bit of a strange issue with Access 2007. I have an access frontend with an SQL backend for my application. There is a report I have that is rather complex and pretty big. About 1 page full of fields and the Query consists of multiple queries to make one final one. In...

Alright thanks a bunch that worked perfectly. See I thought they were doing away with the text field and doing variables like varchar(MAX). I know the inital maximum for a varchar is 8000 chars but the MAX is suppose to really surpass that I thought. Is this a bug in the functionality that...

Yes it's really just a bunch of text. The only odd characters in it are some bullet points but I removed those and that didnt change a thing. How could I test my text weight? Just paste into notepad and save it?

You have a M to M relationship so you can keep that set up or correctly build additional tables to handle the relationships. If you don't mind the M to M then have 3 personID's one for each position. It's really how ever you want the db structured. To get rid of the M to M you would build a...

Hello, Kind of run into a weird issue. I am trying to create some saved imports for some users to import excel spreadsheets into a table. The setup is MS SQL 2008 backend with Access 2007 frontend. So on the backend the field is a varchar(MAX) and on the frontend access displays it as Memo...

1. These are all made up names and I never use them in my db. 2. I understand the Joins it all depends on which side of = sign you want to keep all the records for. In my case it is querya.id = case.id therefore a RIGHT JOIN is used. Remember this is an access inner workings question not a...

This question doesn't involve any coding or query making it is simply a question about how Access does joins. If I have a main table(Case) with all the parameters on it and a couple of other queries (QueryA and QueryB) which are RIGHT JOINED on Case. Meaning all the rows from Case will stay...

Found my answer here http://www.access-programmers.co.uk/forums/archive/index.php/t-141412.html I never would of guessed just entering in the [table].[column] name as the criteria to get all results back.

Changed it up and decided to use a combobox with Yes and No So if they select Yes it will filter by True's on the field and if the select there is no filtering done at all. I enter this in the criteria IIf(([Forms]![ReachQueryForm]![Tech])="No",([dbo_ReachTrip].[Tech_Expert])<=2, True) of...

I am having some issues creating a query and one columns has a criteria that runs against a forms unbound checkbox. I run a MS SQL backend and these particular columns have a datatype of bit. So they are True / False in the backend db. I have an access frontend and the linked table converts...