Search results

yes, substitute your field names for "Datafield1" and so on. To save your self some typeing, just do it for 2 or 3 fields first, to get it working, then add the other fields once it works the way you want it. I would suggest you get this working then go the extra step and use a calendar...

just to make sure i follow....Only 1 date field will have a date at any given time. Once the date is entered into a field, all other fields then become hidden. If this is the case you can try something like this I think: In the fields afterupdate event place the following code: Private Sub...

Hi all, I have a linked table ( see attached image ). In it are several lines with the same invoice number. 1 line with this invoice number has some info I need to retrieve by serial number ( but this line doesn't contain the S/N). My question I guess is how can I retrieve a SerialNumber along...

Good morning all, I have looked at many a subreport thread and haven't come across this issue yet. I have a report linked to a subreport on 1 field, ( child, master). The subreport also has a subreport in it (different child, master). These reports use 3 tables. tables 1 and 2 always have data...

Thats not a bad idea, i may go that way for the short term. Thanks for the ideas.

That won't be too bad to manage. only those 2 systems should ge tmodified ones. I realize it doesn't get me much, but it gives the boss ( who knows nothing about access) a warm fuzzy feeling. So, when I figure the security thing out, we'll all be happy, :D Maybe in the next release, MS can...

If my DB is a BE/FE, can i take a copy of the FE and remove items ( reports, queries.....) and use the copy on a users system. Then take another copy, remove different items and do the same?? I am only asking this since I only have 5 systems to manage and 2 i would like to have limited access...

I got this off this board a while ago and it works for business days, but does NOT exclude holidays. maybe you can start with this.? make a module with the following code: Option Compare Database 'Function to calculate business days, does NOT consider holidays! Function...

ok, solved my own problem by looking alittle more. =IIf([for service subreport].Report.HasData," ","No Service History") works great.

I found this from RICH, =IIf([yourSubReport].[Report].[HasData]," ","NONE") as the control source for your textbox I put in my report name, subreport name and when i run it, what displays is #Name? Whats up with that?

I have found some posts on this, it seems to be using the hasdata property. Now my question is, Where is this? Is this the same as the "on no data" event in the report properties? whats the syntax to show a label of " no data" (label35) when there is no data?

Hi all, I have a report with an embedded subreport. When the linked field is null in the subreport ( but the info is in the main report) I want the subreport to show only a label that says "no data". So i will see the report with the summary data on the top and " no data" on the bottom. Does...

Windows XP Embedded is a conpacted version of Windows XP. Built to fit on systems with only storage devices like 2 gig compact flash cards. Can be installed on larger harddrives, but usually on solid state media, 2 - 4 gig CF. These are primarily in businesses where the user won't be doing...

I had this happening with a foxpro database years ago. it was a bad memory stick (cache) on our raid controller. Documents and regular file sharing weren't affected, just the foxpro application. Was also a novell 3.12 server so this may be grasping at a straw, but just an fyi Kevin

does anyone know if access 2003 will run on a windows XP embedded machine? not building an app, just running one. Thanks

well, i think i have it down now. not sure i like doing data entry blind but this is what the bossman wants. incase someone else needs it, here it is. Private Sub Text14_afterUpdate() Dim I Dim scan As Variant inputloop: Me.Text14.SetFocus scan = Left$(Forms!CopyofFRM_SLABack.Text14, 2)...

maybe moving to a new record isn't easy??

I started toying with using a select case (BELOW) to analize a "value" that gets incremented each time 1 of the 3 fields is filled in and when the "value = 3" then goto a new record, but thats not working either. Is it because my "check" value keeps getting reset to "0"? any other thoughts...

hi all, I have tried a few things with RobertScotts post and still can't get it to go to a new record. below is the code i currently have with an attachment of my form. Would appreciate any help on moveing to a new record when all 3 fields are filled in. Thanks Kevin Private Sub...

maybe this. I think i have a better way of placing the scanned data into the correct fields and eliminating bad scans. see below. I still can't figure out how to check if the 3 fields are populated and move to a new record to begin again. Private Sub A_AfterUpdate() Dim I Dim scan As Variant...