Search results

Now it is working perfectly. Thanks a lot for your help :)

It seems that it is not working properly as no data was given. When i changed it to read #01/01/2008# OR #31/07/2008# only July data was given

Hi, I am working on a query and wish to do the following criteria: TargetShipDate Like < */07/2008 Where I would like as an output only the targetshipdates which are smaller than july 2008 thus in the range between 01-01-2008 till 31-07-2008. Can someone help me pls to set the criteria...

Hi All, I am currently experiencing a problem when exporting an Access Report as Excel Sheet : telling me Subscript out of Range. Any ideas of what it can be? Thanks.

I wasn't even in the tables!!

Hi, I experienced a problem regarding security. I have a table storing the type of access the other users have. All of a sudden one of the users got deleted..and had to reset user. Any suggestions what might have happened? Thanks.

Yes the query runs without a problem

Hi I am getting this error : each time I try to run a report: Compile Error : Method or Data Member not found. Can anyone suggest possible reasons for this? Thanks a lot

Thanks a lot for your suggestions. I will definately take a look through your notes. Thanks once again, much appreciated

The back and front end database is stored on the server, and all users have access to the server.

Hi MStef, thanks for your suggestions. I have actually all settings set that way in my mdb. BUt still it gave me that error

So even though the database is split as back and front end; users cannot update the same table at the same time??

Hi all, Maybe someone can help me. I have a system, that is usually used by 10 people. All of a sudden once, when a user was using it to input some data, it gave the following error: Cannot Update. System is locked. However, I'm sure that the system was not locked; at the time that the error...

Thanks guys a lot for your help and ideas.

Currently both FE and BE are on a common network. Thus better if I leave the BE(tables) on the common network and store the FE(forms etc) on each users' directory. Thanks a lot

In fact the DB is split : thus tables are separted in one db which is linked to another having all the forms, queries, reports etc.

Yep it is actually running on a network..so what do you suggest, so that next time I can avoid such problems? thanks for the help..very much appreciated.

Yes I will definately try that out. Any idea how that could have happened??

Hi, hope someone can help me. I have a table stored in the database and all of a sudden when I tried to input a new record, an error happened giving #Name in the Form and #Error in the Table. When clicking on the field directly in the table, it gave me Invalid Argument. Can someone tell me...

Hope someone can suggest a way of how to go about this situation: I have a Proforma Sub Form that has a Proforma No with input mask "PI"00/000;0 and then on the Proforma Form there is a combo box, used as a Search Facility for Proformas, having the same input mask "PI"00/000;0 The problem is...