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

Its all being run on XP machines. No corruption in the date either... yeah its really strange. No patterns either. Just again - this happens if any user creates a brand new database, adds a few records and tries to create a report. Is there anyway I could have (by accident!) turned off the...

Hello. Yes - the database is split. Its all done through VBA, and its all written properly. Thanks! dj_T

No security at all on the datbase. Thanks, dj_T

Its Access 2003. Cheers.

Hello, thanks for the reply. If I try to create a new report (new button) without using the wizard - also nothing happens. Cheers! dj_T

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 would like to take the value from the text box and send it through some VBA which will then become the criteria for a query. So in my query the criteria would call my function: CriteriaToApply(), instead entering a condition in the query condition. Thanks again! dj_T

Cheers! I suppose I am trying to do it all in VBA? So is there a way to add something similiar to: Like "*" & [Forms].[frmMain]![MyField] & "*" to my original VBA? For example: If (CriteriaToApply) = "All" Then CriteriaToApply = Like "*" & [Forms].[frmMain]![MyField] & "*" Thanks again!

Hello, Its not that it's incomplete: If (CriteriaToApply) = "All" Then CriteriaToApply = ' <= Something here to return all records I just dont know what to put, so thats why I left the comment in. ' <= Something here to return all records What is required is something that will return...

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, Well the record number is added during the import stage. The data is coming from an Excel spreadsheet. It is not possible to specify when to change to another value as the data will change each time. cheers!

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

thanks everyone. I think im maybe going about this the wrong way. im thinking I could just send the field from the query to the function and it would come back with a result? I think the other point is I would like t use multiple parameters. ie. if the string contains MC do Mc or if it...

Replace in function hello, thanks for the reply. I have tried using Replace in a function that I call from a query. Here is the code: Public Function fnReplace(MyField As Field, MyFindText As String, MyReplaceText As String) MyFindText = "OB" MyReplaceText = "O'B" MyField =...