Search results

Still plowing through this, will let you know if i come across anything i cant figure out

Hi Guys, really appreciate the help you all provide in your spare time. Very simple question I just cant seem to figure out. I am trying to link two tabs together. One tab contains a clients details, this is within a form named BasicDetails. I am trying to link it to the form within another...

Ah okay, will have to be something I look into once our full server is set up. With the records being locked to one user, is it possible for this to automaticly skip the in use records rarther than going into them and it saying it is locked?

Still working on this. No i am not using a .mdw file, never heard of one to be honest, will give it a search sometime this afternoon.

Thanks alot for the reply, Going to work on the first part right away. In regards to the 2nd part about stopping people from seeing the same record, basicly the users log into the database through a simple user + password form which is linked to a table, the use of this database is to call...

Still need help

Remade this thread in the Macro section of the forums as i believe the guys there are better suited to help me out

Hi guys, I am reposting a question i asked in the form section of the forums as i believe this question is best solved within the next record macro. The database we are currently using just cycles through all the records in the client information table, which gets its data from an excel...

Still no luck searching for this or just messing with the code, any help would be greatly apreciated

Hello, I am currently trying to figure out how to add a filter to a next record button(using the default access2007 wizard button), the filter will look at the "status" field and not show those records that match "status 1" and "status 2" Looking forward to getting this running, cheers!

Follow up from this, everything was going well and the field was really fast, after afew days it has gone back to how it was, freezing up while entering the name and taking a very long time to even fill in the box. Everything is still indexed so i am really confused. Any ideas?

Got lucky with timing and managed to kick everyone off, have added those two to an index and everything is flying. Thanks alot for the help!

Ah okay, i have gone into the property sheet of the basic details table and it shows that nether the client name nor the partner name is indexed, as the database is currently being used, this is something i will have to do out of hours, I will respond tomorrow to tell you if it has or hasnt...

I think i may have, how would i check and if i have how would i remove them from an index?

Hi guys having a problem with our current database, we are using the query: SELECT [Client Name] FROM [basic details] WHERE [Client Name] like '*william*' UNION ALL SELECT [Partners Name] FROM [basic details] WHERE [Partners Name] like '*william*'; We use this to search for clients in our...

Awesome, that works great, Thanks alot.

I tryed that, no error this time, BUT it hasnt changed the results of the report, it still onlys shows those within this current month and not aswell as next month

Its just a short date format

Thanks for the response, unfortunatly i get Syntax error (missing operator) in query expression. This is followed by the query

Hi guys, been browsing your forums for a long time, first time iv come across something i cant find that i need help with. Basicly we run a report within our access database that shows the clients name and date of distrubution, currently it shows the data from the current month, I have been...