Search results for query: *

The employee supports, develops, maintains and amends existing systems, rather than just using them. Citrix would be fine for someone who was just inputting data or producing reports. This employee, needs to be able to get into the back of the database and not just use the front end. The...

Thanks for all your contributions. We do use Citrix for some things, but unfortunately, Citrix isn't an option in this case because the employee needs amend the database rather than enter data. VPN is the only connection method we have available. Unfortunatley, I don't think working in this...

I know that there are a lot of things that cannot be determined unless it is properly tested. The reason I need the information is because an employee has made a home working request, which would involve regularly accessing and amending access databases. I suspect that even if the database is...

Can anyone help me? I am trying to find out what the performance of a well designed Access database would be, connecting by VPN over a broadband connection. Something along the lines of, if it takes 5 seconds to open on a LAN, then it would take approximately 4 times as long over say a 4mb...

Hello, I am working on a database where i have created a dialog / input form to allow users to enter a key into a textbox to view particular data on a display form. I want the db to check the key entered and see if it matches the key already stored in a existing table if not then i want it to...

I think I may have discovered what was causing this problem. It's explained in the following microsoft help article. http://support.microsoft.com/?kbid=296389#top It seems to be related to memo fields, so I've changed the memo fields that I had in a couple of tables to text fields to see if...

I am having exactly the same problem. It is happening quite regulary and is solved temporarily by compacting the back end database. When the problem occurs it adds a stray gobbledegook record into a particular table. It is starting to be a real nuisance though and I need to find a way of...

Thanks, that's exactly what I needed to know.

I am new to Crystal Reports. Does anyone know if there is a way to allow Crystal Reports to automatically determine the appropriate number of decimal places as, for example, does Access. I am producing a recipe book from a database and whilst some of the ingredients do not require any decimal...

Thanks for your help. Whilst the code you posted didn't work exactly, I had a problem with the copying part, it definitely pointed me in the right direction. I used activecell.offset to move up and down and copied and pasted. I know that's probably not the best way of doing it, but it works...

I have a simple internal requisition form which I want the users to be able to add extra lines to if necessary. As they input items to the requisition form it totals up at the top to tell them how much they have spent. When I insert a row, I want to be able to paste a formula into one of the...

Following on from Lupin46's advice, the following code in the forms onCurrent event with give you the number of the current record out of however many records there are. Me.RecordsetClone.Bookmark = Me.Bookmark txtYourTextBoxname = Me.RecordsetClone.AbsolutePosition + 1 & " of " &...

This may or may not seem like a stupid question, but does your query allow new records to be added and amendments to be made? If the query allows additions, deletions and amendments, then any form based upon it, whatever format, should also do so. If your query won't allow the above, then you...

I seem to be following you around Zameer! Did you find out how to sort columns by date? Thanks

Thanks Zameer Actually that wasn't the problem, the problem was that I was stupidly using the wrong index. That you confirmed that the code should have worked, got me on the right track though.

Hello I am trying to do the same thing as ZmrAbdulla i.e. open a form containing more data of the record clicked in the listview, but using Access 97. I am struggling with the stLinkCriteria and although the form opens, it doesn't open the correct record. The example below is using Access...

Try using the justified form wizard and then amend it so that it looks the way you want it to.

Do you mean that the date function no longer works when you load the database onto your PC? Or, is it that the date function doesn't work when loaded onto other users PCs? It may be a completely different issue, but I a similar problem, using Access 97, when upgrading from Win 98 to Win XP...

In a new column type in the following: CurrentDate:Date()

Cheers rokerij. You have just solved a problem that was causing me to tear my hair out. :-)