Search results

Hey Guys, I've created a couple of scripts that cleans the address data from dataset 1 and 2 and then matching on a LIKE function within the join. But I'm having problems with certain values not matching due to the limitations of the LIKE function. Match Code: SELECT distinct ,ADDRESS1...

Hey guys, i have a quick question regarding forecasting. I have the following values at certain dates; 06/08/2012: 31,000 16/08/2012: 23,000 21/08/2012: 20,000 I want to forecast how long it would take to get to 10,000 and then graph it. Is there any easy way to do this? Thanks,

Hi All, I have a form that uses network ID to identify whether a record has been created by the user on the database, but i seem to get the following error on this code: Syntax Error (missing operator in query expression) 'Staff_id ='. Private Sub Form_Current() Me.employee_lan.Value =...

Hi, I am trying to employ some security on my access 2007 db but with no user level permission i am struggling to get anything going. can someone please help provide a solution? Thanks, ________ Avandia Settlements

Hi All, I recently been looking at access libraries, all of a sudden i can't seem to click properties on anything in design view, can anyone help? Thanks, ________ Michele

Hi All, I have copied a database onto a server which has windows server 2003 and the database is made in 2007. The client desktops are all windows 7 professional, but when i load up the database from a client desktop, it seems as though none of the modules / objects have been loaded thus...

hi All, I have two time fields (from and to) and was wondering if there was a GUI that could select time from and to via a GUI such as selecting a date from the calendar object. Thanks, ________ WEB SHOWS

Hi All, I need help on a query for a post code lookup. I need to design a query whereby I only need the first part of the post code before the numeric digits start. So for example, if the post code is LE1 9PJ, it will only bring back LE. Can anyone please help? Thanks, ________ xSexyAngel live

Hi All, simple question really. i have 15 text boxes with values that can range from 1-5 or have null values. How can i sum all these values up in another text box? Thanks, ________ Volcano solid valve or easy valve

Hi All, I have a table that contains a questionnaire with 3 possible values for each (Yes/No/N/A). I am creating a sub-query for each column so i get a value according to the answer given, e.g; if Yes selected, then value of 3.85 given, else 0. I am using the following statement: Expr1...

Send Email to a Dist List & Have Content Hi All, I would like to send an email out to a list of people with figures from specific tables, i.e. How many items receieved, cleared, outstanding. Can anyone please help? Thanks, ________ Nexium Class Action

Hello All, I have a database that runs a set of de-duplication and update queries. After this is all done, I would like to Open a password protected excel file and then update the pivots automatically. Can someone please assist in module that can do this? Thank you, ________ Zoloft help

All, I am trying to export excel data into an access table via a command button. This is the code I have so far in excel; Private Sub CommandButton1_Click() Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\temp\test.mdb;"...

All, I am trying to export excel data into an access table via a command button. This is the code I have so far in excel; Private Sub CommandButton1_Click() Dim cn As ADODB.Connection Set cn = New ADODB.Connection cn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\temp\test.mdb;"...

Hello All, I have produced a database that looks at workflow reporting. I'm currently stuck on the following problem; Say I have a import of accounts into the database that were Un-worked at the time. After some cleaning of duplicates, the data is then appended into a main table (example row...

All, I have a table that has dates in three fields. The problem is, when I imported them, it was done as a text format. The format is xx.xx.xxxx, I want it to be a short date; i.e. 01/01/2008. I have tried converting it through the table design view, but it says not enough memory. How can I...

hi all, I'm trying to create a field whereby IF the masterkey is Like Target, then "Target", else "not target". But I can't seem to use the Like function in the field name and I get the error "You have entered a comma without a preceeding value or identifier". here is what I have; Expr1...

Hi all, I basically have three cell values (month 1 of a quarter, month 2 etc). I have created a dropdown with values; Q1 2008, Q2 2008 etc. So for example, when Q1 2008 is selected, the first cell is to change to 01/01/2008, second cell to 01/02/2008 (based on the quarterly combo value)...

Hi All, I have a macro that exports (transfer spreadsheet) queries into excel. But since I have put a password to modify the data in excel, the macro can't export the data into excel. Is there a way around this? The error message I get when trying to run the macro is "Cannot Update, Datebase...

Hello All, I have a Pivot table that updates every week, but I also have two columns connected to the pivot but if a new row is created as a result of the pivot update, I want a row created to calculate the value. here is what I have so far, all it does it drags the total values and then drags...