Search results

I just returned to follow up - yes it is "form_current"! Thanks Ray! -Sean

Hi all - I'm having one of those days where I just can't seem to get something that seems so simple. I need to run my event on a record change (when the user changes the record using the navigation buttons). Do I have to create my own navigation buttons, or is there a "On_record_change" event...

No problem Toni! here's a quick sample: @echo off if not exist \\Server\Directory\*.* goto err_msg M:\folder\dbname.mdb goto done :err_msg @echo on @echo You do not have permission for this folder. @echo Press any key to close this window. @pause>nul :done Now, at my work we don't restrict...

Hey Toni, Is the .bat file in a different folder than the db? and do the users have access that folder? (does the batch file run for them? or does the PC "freeze" before that?). If the batch file runs, then add an "IF" statement to it (I can help you quickly with that). If the batch file...

Hi Ann, Dim I As Integer DoCmd.OpenReport "Your_Report_Name", acViewPreview I = Reports!Your_Report_Name.Pages SendKeys "{F5}{Delete}" SendKeys I & "{ENTER}" Hope that helps! -Sean

I see what llkhoutx's saying too - it depends on what you mean by "variable" or by when you determine its value. If you've already suceeded in determining the value within your VBA, then use the solution I posted - if you have not yet determined it, then use llkhoutx's. Just to be sure - if...

Hey Mark, In the PageHeaderSection (Format), put: txtYourTextBoxName = yourStringVariable It's as simple as that! - and the variable does not need to be (and should not be) global. -Sean

My guess would be that your users only need a browser to view data and don't need Access ...? Personally, I like Coldfusion and/or ASP. Either way, they are tools to create dynamic web pages - meaning that changes to your database will reflect immediately on your site. -Sean

Hi Wayne, you were right on the money! Not only did compacting it work, but it also automatically changed those fields to what I was trying to rename them to. The sad thing is, this isn't the first time that a simple "compact & repair" fixed my problem - I need to remember to do that more...

Thanks for confirming Pat! -Sean

Hello, can comments be added in Access queries (in SQL)? I think in other versions of SQL you can use double-dash (--) or "rem" - but I can't seem to get any of that to work! Thanks in advance, -Sean

Hello, I've just started to rework a database (the original creator is not available). I am trying to rename one of the fields ("oldfieldname" to "newfieldname"), but when I try to save it I get an error message saying "Could not find field oldfieldname". Clicking on "help" gives me: Could...

Hey Namlian, I once worked on a database filled with names like: "Query to determine what the latest status on a application is (with dates)". All of their folders on their network were like that too (not as bad as that one though). Anyways - all to say that you're right, no spaces should be...

Hey pungentSapling, try: ... .workbooks.open("""file name.xls""") (three sets of double quotation marks) -Sean

Hey Daminc, You have a couple of options that I can think of: 1) You can create new forms from scratch in Access (and just follow the design of your ASP page). 2) There is a browser viewer you can add to a form that will display your page (from Design view in your form, click the "More...

Thanks everyone! - sorry to Friday though (I feel like I took over your thread):) -Sean

Thanks dcx693, I plugged away at what I posted above until it worked. In my head, "rst.RecordCount=0" makes logical sense - can you tell us why it doesn't work? In testing, I found that rst.RecordCount was always "-1" - wether it found any records or not. -Sean

Hey Dugantrain, I haven't tested this - but I don't think I forgot anything (let me know). Dim adb As String Dim dbs As Database adb = "Microsoft Access" Set dbs = OpenDatabase("C:\Your_Database.mdb") On Error Resume Next dbs.Execute "qryFromYour_Database" dbs.Close Set dbs = Nothing -Sean

Hi Friday - I see what you mean about this! I thought it would be fairly simple, but ran into problems. Here's the closest I could get (but now I have to go back to work:() - I wanted to go "rst.RecordCount = 0" but obviously I need to learn a bit more about it! So, button on your main form...

Hi again, I should've been clearer about something on my first post - what happened was that on a copy of my database, I tried to replace all spaces with a comma followed by a space for a particular column. Usually, I would it would change: itemA itemB itemC to: itemA, itemB itemC so I would...