Search results

Hi All, So i have 2 tables: Invoice List and Case List. The fields of interest are; [Invoice List].[Customer] - Short text [Invoice List].[Invoice Date] - date-time [Case List].[Customer] - short text [Case List].[Created On] - date time I have a query that returns records in [Case List]...

Hi all I have a currency table that stores the currency name, trading code and exchange rate. I also have a TRUE/FALSE field for the default currency (the base currency being used by the company using the database). At any one time only 1 currency can be the default. Currently I use Before...

Hi all A database that has been in use for 3 years, has suddenly today decided a query data source is not updateable. The query includes PK and FK from all parent record sources. The parent record sources are updateable manually. I tried deleting and recreating the query and form that are...

Hi All I have a table of technical terms (1 field) [tsTrm]. Users enter details of work performed in a long text field [wkPrf] of a separate table. What i would like to achieve, is as you type, lookup of the [tsTrm] records matching the current word, and 'suggest' that word. Most reports...

Hello guys and girls, it has been a while since i was around. Hope you are all well? I have a BE database whose tables overtime have become the source data for several excel spreadsheets and been linked in other FE database. Is there any way to see active connections to the BE database?

Hey gang :p I am looking for a way to check a string for gibberish. So aaaaaa, bbbbb, lsdjadjlajdkljas etc is not allowed. Now i have done this thus far for aaa bbb etc by using INSTR() through a loop through an array, but obviously you need to anticipate EVERY conceivable piece of gibberish...

Hi Guys I am looking for a solution to delete records in one table where a field = a form selected value and the FK is also in another table where a field there = a form selected value. Setting: I have a join table (it creates combinations of Sites and Sectors covered by each Site). The PK is...

Hi everyone. On several reports on 2 different databases, users are getting "The Output to Action was cancelled:2501" message when trying to save a report as PDF via OutputTo action. Equally when trying to manually save as PDF they get "cant save the output data to the file you've selected" (on...

He all My company has just switched to a new server. I have gone through a DB re linking the tables to the new location of the back end. However 1 table (HICC_List) would NOT link. It kept hitting me with "cannot open or write" error. So i thought create a new link, rename and delete origal: I...

Hi all I have a table that includes a boolean field called recSlct. The purpose of this field is to allow a user to select multiple records on a continuous form to then carry out a range of tasks (view detailed data, print reports, update statuses etc). This works all well and good in single...

Hey all, Normally i build forms from blank. A colleague asked me about the 'new' view options in form wizard. Not being aware of this, I just went to create a new form using the wizard. The recordsource is a query pulling data from multiple tables. After selecting the recordsource, i am asked...

Hi everyone This one has me stumped. I have a bound combobox on a form (rowsource form a separate table). When trying to check the combobox.oldvalue in the BeforeUpdate() event, I get an "Invalid use of Null" error. The combobox does have a value prior to triggering the event. Oldvalue should...

Hi everyone, I am trying to 'fix' a Supply database, author unknown. I have created a query to provide a goods in diary, but the resulting recordset can not be updated. I have provided a screen shot of the relevant relationships. There are 5 tables; Purchase_Orders_List - Stores the PO ref and...

Hey guys, I am pulling together a database to control invoices and proformas and the payment of. These will come in different currencies and non GBP will be paid in that currency via a trading site (best rate!). I need to record the original value and the GBP after exchange. I have hit a snag...

Hi guys I am having a hard time figuring this one out. I have a table - RDC/NDC - that holds details about various warehouses, including a field - [Short_Code] (TEXT) - to hold the warehouse short code or ID. I have an import table - PickDataImport - that contains details of goods picked...

Hello community I have a table [PickData] in a WMS (Warehouse Management System) database, that records details of each item picked. The key fields are; [Movement] - a unique ID for a collection of items to be picked. [ToAssignRef] - the order ID [Product] - the product! [Picked] - the...

Hello community I have an issues tracking database where the operator can email the ticket history (using ColumnHistory from a LongText field) to relevant persons. Initially I used a macro using the EMailDatabaseObject action. This works fine but then they needed to add attachments. I have...

I hope someone can help on this, its driving me crazy. I am trying to Dlookup() a value in one table based on a date. I get nothing! no errors, no nothing. If you look at the attached, i have designed a test query - qryPickTotals - and i have put in 4 calculated fields each a differenct...

I am getting this error in a query. The field generating the error is a calculated field using a custom function. The function is: Public Function DecimalTime(dblEvalTime As Double) As Double DecimalTime = Hour(dblEvalTime) DecimalTime = DecimalTime + (Minute(dblEvalTime) / 60) DecimalTime =...

I have been crunching this all day, but i am missing something, so hopefully one of you guys will solve it. I have 3 tables; tblEmployees - Stores employee data tblProcess - Stores process data tblTraining - Stores data on which employees have trained on which process tblEmployees has a 1 to...