Recent content by deejay_totoro

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!