Search results for query: *

I have a few posts about this issue but I don't seem to get iit sorted I have an update query that runs in about 40 secs on the local machine but so far I have killed it after 2 hours over the network. I have tried many things including turning autoname off, adding and deleteing indexes...

I have a database with very few users, it is stored on a network and has user level security, Access 2k with the auto name correction switched off. I run a very simple update query during an import process where I import from a 3rd party logistics system. After import I update nulls in the...

I am using a databse over a network, when I use a Macro using RunCommand SelectAllRecords and RunCommand Delete it has a record Locking error. I can only assume this is due to inefficiencies in these commands causing time out performance issues. I have tested the same process using a delete...

I have the following code to exit without saving and entry on a data entry form: Private Sub Command10_Click() On Error GoTo Err_Command10_Click Dim Msg, Response, Style, Title As String Style = vbYesNo + vbWarning + vbDefaultButton2 Title = "Do you wish to exit" Msg = "Exiting...

I have a crosstab query which builds its fields using a DateDiff function. I then use a standard append query over the crosstab to append the data. in this query I use the Nz function to return nulls as 0. However, if I use the Nz function in only the 1st field it works fine but if I use it in...

I have set up userlevel secuity on a databse. It all works fine. I have a shortcut to the databse with the workgroup detail in the target also works great. If I try to access the database without using the shortcut it is not possible to access, also great. However, if someone copies the...

I have a macro performing a process where it opens a table selects all records then deletes all records. It works fine when I run the process locally but I get the 'Could not Update; Currently Locked' error when I run it on the network. I have database set to exclusive and there are no other...

I am importing data into a database from .txt the file is always named the same way with the exception of the last 4 charaters defining the period name e.g Expenses_Export0604.txt for period 6 2004. Expenses_Export0704.txt for period 7 2004 I want the user to be able to select a period for...

I am using popup forms in a database however, when i want to display a report it opens beneath the poup form. I can close and re-open the form but I then lose the selection on multiselect listboxes. So I thought if I can change the popUp setting to = false before the print preview it woud...

Hi I am designing a form for updating a price list. The prices have effective dates so instead of updating the current record I add a new record and update certain fields. I have it setup so the user selects the record they want to update. This record is displayed (uneditable) along with...

I had posted this same question on the forms forum but to na avail. I have 2 user groups (sales, marketing)that generally are kept separate - using user-level security and forms for navigation. They now need visibility of each others reporting. The forms run in POp-up modal format. On the...

I have 2 user groups that generally are kept separate - using user-level security. They now want visibility of each others reporting. The forms run in POp-up modal format. On the OnClose event of the reports I currently have the user sent back to their respective forms i.e. if a sales report...

I have a form that allows users to update info. This automatically pops up all records with a null in a particular field and allows updating via a combo box. I then check the table for nulls (using Dcount) again when they try to close it and don't allow close where a null still exists. The...

I have a query that is attempting to do various calculations to later be use to append another table. I want to allocate period numbers. The original records have a start_date and I have another table GLPERIODS that has start_date and End_date and period number. If the start_date of the...

I am working for a company that has change a large chunck of teminology eg from profit centre to cost centre etc etc. If possible I would like to change all fields in a database and then all related references in queries, forms and reports as well code. Does anyone have some sort of program...

I am quite new to this VBA stuff and I have actuallty posted this question in another area but it seems very complicated the way I 1st posted it. I have written the following code: ******* Private Sub Command0_Click() Dim strSQL As String Dim strOldSQL As String Dim txtDeptNo As String Dim...

I have a database with 1 update query for each department i.e. department 1 - 160. The update query updates a table (simply storing the deptno) that is then used to make another table and print a report. What I want to do is use code to loop through that process, ie for each record on...

I had previously posted this in the forms forum but to no avail. I have the following code: Private Sub ctrtxtChequeNo_GotFocus() Dim dblCount As Double Dim dblHeight As Integer dblCount = DCount("[txtChequeNo]", "DuplicateChqNumUnmatched", "[txtChequeNo] =...

I am working in Access 2000. I have Bank reconciliation form, frmBnkMain and a subform frmBnkDet. frmBnkMain displays the total for a given cheque number, frmBnkDet displays each cheque record. The forms are linked by cheque number. When I select a new record from frmBnkMain (the aggregate...

I have a report and a subreport. That report is based ona table and has a filter coming from a multiselect listbox. tis report is grouped by; Brand, LPGCode. The detail includes the field Account. The subreport source is a query that essentially rolls up the records on the table in the main...