Search results

Hello Old Soft Boss, I'm trying to replicate the above code for another database I'm creating for my company. But I'm getting an error with this one. Can you see anything that I'm doing wrong?

Hello, I have a welcome screen (form) that I would like to open automatically when I open the database, but then I would also like that form to close after three seconds and for another form to open. I know someone here has done it because I've seen it before in the sample database forum...

I made those changes in my db, but it didn't recognize the file locations. An example of how I used it was - Original: Replaced With:

so how would you go back a folder (directory?)? Is that "..\"?

Hello, I've been using C:\Program Files\... in my codes to tell the database to locate a file, image, etc. Someone told me recently that there was a way to use ".\" instead of a hard location in my code to tell the program to look in a folder using the .exe as the starting reference...

That be it! Thanks again for the help.

Thanks for the help on that one. Here's a new one, though (if you don't mind). :) I'm trying to have one form button select the source object of a subform within another open form. I tried using these but they came back with an error or "object required" frm1.subfrm1.sourceobject = "frm2"...

I figured out the problem (I think) using your website! You offered the following code: But I think you accidentally left out this: Am I right?

You are correct on this assumption. I'm looking at your webpage now to try and figure it out so I'm not just copying and pasting(I tried the codes you offered, but couldn't get them to work). xxxxxxxxxxxxxxxxxxxxxxxxx Oh, except that subform1a (the form, not the container) has a button in it...

Hello, I've successfully used the following code to allow buttons on one subform to control the source object of another subform: frm1 subfrm1 subfrm2 buttons controlled source object me.parent.subfrm2.sourceobject = frm2 me.parent.subfrm2.form.requery Now I'm trying to allow subform...

It is based on a query that draws from a table. My problem is that, being a newbie, I don't have the slightest idea how the macro should be written.

Hello, I have a multi-select listbox that, when records are selected, sends those records to a report. I would like to create a second button in my form that sends the same data to an Excel Spreadsheet. Is this possible? Listbox name - lstHidden1 Listbox source - qry1

Hey Lister, Sorry I haven't been on for a while. Things have been kind of busy. I promise I'll get a copy of the database on soon so you can see what I'm dealing with. brsawvel

I don't know specifics, but I know that WASP handhelds (i.e. WPA 206) use a windows operating system and can connect to the internet through a PCMCIA card. Check it out, but it may be possible to maintain access to your company webpage remotely. As far as alerts telling your employees that they...

That fixed it, thanks for the help.

Ok, I think I fixed it, but I want to make sure it's a complete fix and not a quick fix. In the code I saw this: If vVal <> Empty Then strHolder = strHolder & "'" & vVal & "'" & " Or qryListed.fldAssetID = " With that I was getting the error message: I kep thinking that "0" near the...

It worked fine when I first used it, but after I added a record to the table, I got an Error stating - Any idea what that could be? I looked online to see if I could find an answer and came across this webpage - http://www.tek-tips.com/viewthread.cfm?qid=1268276&page=9 Is that similar?

When I open a report by a command button within a form, it opens behind the form. Is there a way to have it open in front of the form?

Hey Lister, That's awesome. I've got a little more reading to do on it, but I think it will work on my actual db (not at my personal computer right now so I can't check yet). I tweaked the code to report from the hidden listbox and had to correct the code on the select all button like...

That must be a mistake I made in the sample db above. I do have it the right way in my actual db. My bad.