Search results

Well whatever the problem was yesterday, it seems to be working for her today. I hate these types of problems, never know what actually caused it.

Hi, I hope someone has an idea to why this is happening to only 1 user. Whenever they try and open the db, they get the following message The Microsoft Jet Database Engine stopped the process because you and another user are attempting to change the same data at the same time. It then shuts...

Hi, A friend asked me about how to do this, and I was assuming it was a number field, but once I tried to test it on a test db, I realized it had to be a text field. I was able to get it to work using the right function. Thank you everyone.

OK, not sure if this is right but what I did is put this in my criteria. Not Like "******000" That seems to work, but now I have something else I need to do. All the records that this query finds, there are a matching record that does end with 000. for example 0054541002 would have a...

Hi, I know I've seen this done before, but now I can't find it. I have a field in my database that has a 13 digit number, I need to find all records that end with 001, 002, 003 etc. Basically I need to find all records that don't end with 000. I'm trying to recall how it's done, I thought...

I hope someone can help me solve this random error, that only some users are seeing with my data entry form. I have a main form that displays the users info. Then 2 subforms, The first subform is the data entry form, and the second subform displays all the entries that the user entered today...

So far I can't even get anyone at MS to admit there is a problem :( I posted on the MS forums about it, and one of the MVP's posted and said "Not sure why it would do that" said he had a meeting with 26 of MVP's the next day would would ask about it and would report back. Never heard another...

Hi Tibs, thanks for replying to this post. Unfortunately tho, I had already tried what you suggested and it doesn't work :( I've tried it both way actually, first creating the query to run against the access tables, then publish. Then also, creating the query to run against sharepoint...

I've tried everything I can think of, nobody on the MS site will even respond to my post. This is really upsetting, I spent all this time working on this, and going to have to tell them it won't work because a simple query won't run properly. It has to be some sort of bug in either...

I was wondering if anyone here has access to Sharepoint? If so, could you do a test for me. Create a list, then link to it in Access. create a query, just a simple select query. Now add a column, and give it an alias. When you run the query, does it display the alias name, or the table...

I went over to the MS forums, and found someone else having a very similar problem with using an alias against a sharepoint list. Instead of the alias name showing, it's showing the column name...

It should be possible to use an alias still right? I still don't get why when I run the query against the sharepoint lists, that the alias column displays the table column name instead of the alias name.

Sorry I didn't get back to you until today, I didn't get the email notifications. yes, that's how the query is suppose to work, it lists each employee and then lists a supervisor that is associated to that employee. When I have the tables in access it worked great, then I moved them over to...

Hi, I just moved my Access tables over to Sharepoint. I'm now using Access and linking to these lists. Basically Sharepoint is going to be the backend, and users can use Access to run reports if needed. Here is the problem I'm running into. I have a query that uses an alias, it worked...

I've seen these, but don't think it solves my problem. I could create a 'access view' but that just creates an 07 database that the user I guess downloads to view reports or something. Most users here only have 03 so that wouldn't work anyways. I wish Access didn't discontinue Data Access...

Hi, Just wondering if there are any Sharepoint users here, that are using Access in their sites? Since Access 07 removes data access pages, I've been trying to find another way to display data from a exisiting database on our intranet. We are using Sharepoint, and I think this is going to be...

I'll see if our guys will let me have both version, otherwise going to have to convert back to 03. Thanks for the info!!

UGH, I did not want to hear that. I guess I'll have to ask to be downgraded back to 03, since they are only letting very few try out 07. Users aren't allowed to install the 07 runtime on their own. Can both 03 and 07 be installed at the same time?

I just upgraded to Access 07, and I'm working on an 03 DB. I need to create the MDE file, but maintain it in the 03 version so everyone else can still use the db. When I create the MDE tho, nobody with 03 can open it anymore. They get an unrecognized format. Is there a setting somewhere...

Hi, Didn't want to start a new post on something so similar to this. I'm trying to make it so if the ID of this field is <1 display 'NONE' Otherwise display the Policy Name using the policy name field. I was trying something like this. =IIf([Policy_ID]<1,"None",[Policy_Name]) But just...