Search results

Hi, I wonder can I do this....I have a form which views data from a number of tables, and shows a lot of data. I then use simple criteria to narrow my results down and view the data I am looking for...fine....now I want to add a button on the form to produce a report which will only include...

Hi, I have a growing Access database in a multi-user environment over a 10/100Mb network. The database is all in one file at the moment, on a shared directory of our XP-Pro 'Server', and the workstations have a mapped drive to it and are W98SE machines. All the machines are 1.2Ghz Fujitsu...

Hi, Has anyone seen this one? I have a form on it with a date field, and want to use that date field as a criteria within a 'where' statement for a report. Problem is that on the form, if I extract the date to a variable, it comes off in a dd/mm/yy format, BUT when I want to include that...

Hi there, I am using access a lot these days, and try to use keyboard shortcuts where possible (leave that mouse alone....), so does anyone know a way to get to the FILTER menu when viewing a form using the keyboard...i.e without having to right click on the field and then click in the FILTER...

Hi there, I have a question which I am sure is simple, but so am I. I have some standard letters printed by an access system, and the users get tired of signing. I have scanned their signatures into tif files, and ctreated a table with the CurrentUser name and the picture of their signature...

Hello, I have created the query as shown below, and it works fine when I click the View button, but when I use the SQL from it to create an ADODB recordset it contains no records!! Its part of an enhanced Switchboard I have, and it is driving me nuts!!! Can somebody please shed some light...

Further to my 'Enhanced Switchboard' thread, I almost have a great solution, but the last hurdle is causing me ENORMOUS frustration. I have added a field to the 'Switchboard Items' table called 'Description', and it contains a description of what the item does, so the option to print a sales...

I wonder if anyone can help me puzzle this one out. I have nearly 200 items in my switchboards table, and a lot more to be created yet. I have added a field to the switchboard table with a memo type, and put a description of what the item does in it. For example the Item Text might be...

Hi...I have a question. I have a form that lists some fields in a continuous form, one of the fields being called 'Include?' and of the yes/no type. The user puts a tick on the records they want to use, then clicks a button in the footer of the form to do a certain ACTION on the records...

Hello Folks, I have some pretty complex queries that run with the docmd.runSQL method, and some take up to 30 seconds to complete. How can I put something nice on the screen to tell the user it is still working, rather than just having to watch the blue bar in the status bar, or wait for the...

Hi, I have a table with two fields...'Project Number' and 'House Type'. I have another table with three fields...'Project Number', 'House Type' and 'Bill Number'. Can I use an Append Query to create records in the second table, with the additional field created in the query as a sequential...

Hi, Does anyone know any code that can tell me what users are currently logged on to my multi-user database? Thanks

Hi there, I am developing an application with several sections in a multi-user environment, and want each section to go live as it is complete. I read about splitting into Front-End and Back-End etc, but found problems with speed and reliability when I split it, so I am keeping it all in one...

Hello clever people.... :D I have a switchboard which can call up various reports in Preview mode...nice. When I do though, they come up in a window, and I then maximise them to view the whole page width. Then when I close the report, my Switchboard is now full screen, and looks odd, so I...

Hello.... I am working on a major Access project, and wish to start putting it out for users to Beta Test for me. How do I produce a safe, working application, without letting people gat at the raw database or code etc. I have Access installed on all the machines that need it, and I also have...

Hi, Here is the problem. I have a table with Rows of data in fields: EmployeeNumber (integer) Work Type (either a 0,1, or 2 Value (Currency) Like this... Employee No.........Work Type......Value 999.........................0............100.00 999.........................1..............20.00...

Hi, I have a problem updating records with data from a form. Here is the scenario. I have two fields on the form, which create two variables 'intContractNumber' and 'curRetentionHeld'. When I click my Accept button, I want to locate the record in a recordset and write the new data. Here is...

Hi, I am sure this will be childs play to many, but its my first time trying to get data into a table from an unbound form. There are several unbound text boxes on the form, and certain data needs writing to different tables. Sometimes its amending an existing records, and sometimes creating...