Search results

I think I found a bug in 2007; I am wondering if it is new or if it is widely know about and I have been living under a rock. I did a quick search and didn't see anything about it so I am hoping you folks will let me know. I created a form in 2007 using the wizard and then modified it. For...

Thanks Oldsoftboss, that will work very well. Is there a way to do this behind the scenes though? I have a search box that can search the main or sub part and would like to have the user only enter the search info in this field instead of opening another form. Thanks for that idea though, I...

I have a parts database, part of it's function is to track main parts and sub parts. For instance, say main parts are laptops and desktops. Sub parts are displays, hard drives, keyboards, video cards, and so on. I have a form that would show all different types of main parts. It has a...

I was able to figure this out, here it is for anyone that runs into this problem. ECHO OFF START \\ServerName\"Directory Name"\StartMDB.exe /cmd /inifile: "\\ServerName\Directory Name\Yourinifile.ini" This is all one line of code and goes in a .cmd file. The first part tells it to start...

I am actually using the one by Tony Toews; available here http://www.granite.ab.ca/access/autofe.htm. Guus2005, the actual database works correctly; I have used UNC paths in the linked table manager. The problem is getting a shortcut to the executable and ini file for the front end updater...

I am using the Auto FE Updater to update the FE's of my database over a LAN. The utility is setup and working normally for the most part, but I have one little issue that I can't seem to find any info on anywhere. There are two groups of users that are only separated administratively (not...

Does anyone else have any info on this? I would still like to do this based on the related table instead of just duplicating the last status in tblMain. It will allow me to do other things (like show the status of a record on any given date) if I can figure it out.

Thanks for the reply. That is what I was trying but when the query runs it assumes that I want the top value where "In Work" is the status instead of the top value and associated record if the status is "In Work". I can't think of anyway to make it work but I am certainly open to suggestions...

Well I hope I didn't mess up with the design of my database but I can't seem to find a way to do what I want. For simplicity I have two tables; tblMain & tblStatus with one record in tblMain matching many in tblStatus. I can do what I need in my head but can't figure how to get Access to do...

No, YOU got it! Thank you very much for your time and effort. It is great for someone like me to have a place to go for help when needed and I really appreciate all the help provided on this forum.

I was simplifing the form/control names and I didn't catch I was holding the shift key whe trying to type [], sorry. Good news though, running the Call MyPublicSub at the bottom of the command button code fixed it. I guess that means the values are passed after the form loads not before or...

Here is the code for the command button, notice it is a select case that really only has one case right now but will get more. {Code} Private Sub cmdPrint_Click() On Error GoTo Err_cmdPrint_Click Dim stDocName As String Dim stLinkCriteria As String Select Case Me.cboPrintSelect...

It doesn't seem to work with the OnOpen either. I wonder if it is a problem with the combo box value getting set after all of the form events have happened. The value is set when the command button is clicked by something like this {Code} Forms!FORM2.ComboBox = Me.txtStatus {/Code} FORM2 opens...

That is what I have been doing, it works calling it from the combo box AfterUpdate on FORM2. However, it doesn't seem to work when I try it from any event on FORM2 itself. I don't get any errors or anything, it seems like the form is just loading normally. Believe it or not though I haven't...

I got it to call the public sub on the AfterUpdate event but still can't find an event that will work when the form is loaded via the command button on FORM1. I tried OnLoad, OnActivate, OnGotFocus, & AfterFinalRender; any ideas?

Thanks, I was just about to ask if you thought that might work. I will give it a try now.

Bob, I just tried that and it seems since it is an unbound form acCmdSaveRecord has no effect.

I have two forms, FORM1 & FORM2 (not their real names). FORM1 is a standard bound form and FORM2 is an unbound form. On FORM1 I have a command button that opens FORM2 and passes values from numerous fields on FORM1 to FORM2 for printing. On FORM2 I have a combo box that is used to set...

Thanks, naturally that worked! I thought I had already tried that; guess I must have fat fingered it and not noticed.

I am attempting to show a custom julian date format in an unbound text box and am currently using: =Format([DateOpened],"yy") & "" & Format(Format([DateOpened],"y"),"000") This results in a format like 07117 which would be the 117th day of 2007. I would like to trim the 0 from the front of...