Search results

Hello, It would be great if someone could help me with writing a function. The function will parse a string which can have any number of words, ie: "This is a string with spaces between words". If a certain rule is met, ie: "wor" or "str" or "ith" then the function will subsitiute those...

Hello everyone, Im not sure if I am explaining this correctly - but here goes! I have pasted a table to Excel from Access. No problems there. I then want the Excel users of this spreadsheet to choose a comment in a cell beside each record (row). I am using "validate" to give the users a...

Hello, I would like to remove a specific character from every field in a table, a "%" for example. I have found code that will let me remove the character from each field individually, but this means calling the function for each individual field... ie: cleanMe([fld1]), cleanMe([fld2])...

Hello, I am trying to do a simple division. But I am getting an #Error when Access query tries to divide 0 by 0. Here is my example: fldOne = 0 fldTwo = 0 fldCalc: IIf(([fldOne]/[fldTwo])=0,0,([fldOne]/[fldTwo])) result = #Error However: fldCalc...

table Thanks for your replies.

Visual Studio... and Access2003 Hello, I just started to get the same error, after install VS2005. The error is: Microsoft Visual C++ Debug Library C:\Program Files\Microsoft Office\OFFICE11\MSACESS.EXE abnormal program termination (Press Retry to debug the appliation) Does any one have...

field... It is actually field. I tried your suggestion but didnt work :( However I suppose another to do it would be to put the date on a form and then reference the form (which works)... but I would have preferred to just reference the table.field from within a query without having to use a...

Sql Here is a simple version of the SQL: SELECT tblDate.date FROM tblDate WHERE (((tblDate.date)=[tblPromptDate]![promptDate])); Cheers!

Build... Hello, Thanks for the reply. I did try using the build feature. still get a prompt... Cheers!

Only one date There is actually only one record and one field in the date table. cheers. dj_T

Hello, I would like to reference a field value in a query, and not sure how to do this! For example, I would like to query all purchases by [myTable].[my_field]. When I try this in a query, Access keeps prompting me for a value and doesnt use the actual value in the table. How might I achieve...

Hello, I have question about global variables - well I think thats what it is! I am familiar with (private?) variables in functions. But what I would like to do is set up a few "global" variables that would be available to any module/function/form/query within my database. The variables are...

Hello, I have a short simple function that when triggered runs a few queries. At one point a from opens up which the user must complete. My question is this: I would like the function to "Pause" until the opened form is closed. Is there anyway I can get the function to "wait until the form...

Hello, I'm trying to import a series of Excel .xls files in to an Access database, Using the following, the spreadsheets will only import if they are already opened in Excel. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "myTable", myPath & "\spreadsheet.xls", True...

Great Thanks! Works great. dj_T

Hello, I am trying to take the value of a text box and include it in the file name of a file that is exported from a database. The code looks like this: dim strFileName = some text box date value strMyVariable = "c:\directory" & Format(Date, "DD / MY", strFileName) & ".csv" Basically I would...

Hello, I would like to format the currency values in a query. There values will either be Euro or Pound. Is it possible to change the currency format "on the fly" in this way in a query? I would like to have a variable currency format. For example: If [fldCurrency] = [Euro] Then format...

Hello, I want to set a date in the field [MyFieldStartDate], from which queries will be run. The start date cannot be on a Saturday or Sunday. (For the moment I am not concerned with national holidays.) If someone could help, that would be great! Here is psuedo code if what I want to do: If...

Hello, I am trying to create a unique reference number that includes the default autonumber and another count based on what the user selects from a dropdown (B). For example, the reference might look something like these examples: Auto DropdwnA DropdwnB Count 001 Drink Mocha 1 002 Drink...

Hello, I am trying to calculate the total number of hours. I started by creating an underlying query that produces a decimal total. I then use the Format option to re-format the decial value into a time value. This is fine however, the problems occur if I try to calculate a total in a report...