Search results

Hello, I've been learning a lot from this site over the years, from my first Access forms, to functions. Now I am trying to do a small project using SQL Server and ASP (Visual Studio VB). What I would like to achieve is this: A web font end, made up of 20-30 fields. User enters data User...

Hello, I am trying to automate the formatting of an Excel spreadsheet from Access, using VBA. I have managed to do most of what I would like to do by first creating a Macro in Excel then using the macro code as a basis for the VBA code in Access. But I have run into trouble to trying to...

Hello, I have been experimenting with Visual Studio and VB a bit but was wondering if I am heading in the right direction? Or if I completely missunderstood! I use VBA functions to extensively automate queries in Access. Nothing too complicated really but I would now like do the same thing in...

Hello, I hope someone might be able to help with this report question. I am having some trouble printing out custom reports from certain machines. I have a command button that opens a report in preview mode. The user can then print reports etc… However I am finding that a number of users...

Hello, I would like to import a spreadsheet that contains a number of woksheets, into separate Access tables. I don’t know what the field names will be on the spreadsheets. My question is: does anyone know if it is possible to import an unknown number of worksheets into separate tables in an...

Hello, I am trying to pass the value of a text box to a query using VBA. What I have written is not working. Does anyone have any ideas? Public Function CriteriaToApply() ' First get value in text box. This will be the criteria applied to the query CriteriaToApply =...

Hello, Any help would be appreciated! I would like to populate field 1, based on the last value (not null) found in fld1. For example in recno 2 and 3 fld1 should be "1"… and recno 9 - 11 should be "4". Here are some examples (below.) Best wishes, Dj_totoro Original recno Fd1 fd2 01 1...

Hello, Would anyone know if it is possible to change the value of a field using the mouse wheel? For example, I am currently using two buttons either side of a text box, that when clicked will increase or decrease the value in the field. Could this be achieved using the mouse wheel? for...

Hello :cool:, I am not sure of the best way to achieve the end results - so hoping someone can help! I have many queries in one database that all use the same criteria, for example, in a table with a list of names, I select the following names:: Jones Smyth Cameron Blair Brown The list is...

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...

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...

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...