Search results

Can you post a sample db?

I use an Audit Trial feature on my main form also. I got the code from some site. It works good. But I noticed that the field required in the table does not get populated with data unless I type something in the box. I dont have that field visible on my form but just tried to enter data and...

First of all, your table design should not be where you have a bunch of blank fields. Consider redesign of your tables.... Second, you said you need to have all lables on your report...but not fields have data... You could loop thru the controls to find null values and insert a value of "NA"...

Just set focus to some other control first in your order of things.. that way the control your trying to hide doesnt have the focus....

I have a Star Office file that is 600 megs in size. Yep, 600.... It's a spreadsheet. I cannot open it because I dont have the 5.0 version of Star Office (which used to be a free download) Is there a way to grab the data using Access? I tried Excell but it will only import 20k rows and wont do...

Yes, the recordID gets picked up when a task is created and then matches the other tbls recordID. But both reports are grouped bt employee. I need to show the main projects they have assigned and tasks below this list.

I have 2 queries for 2 reports. Id like to combine them. Heres how they are: qry1: Employee, Project title, RecordID, Status qry2: Assigned Employee, Task, RecordID, Completed What Im trying to do is show what each employee has on thier plate. Only one employee is responsible for each project...

Sorta, it doesnt find the recod(s) though.... I made sure I was selecting ones that existed in one of those cbo's in the main tbl records....

Thanks RichO, I tried this but it returns a blank form. I edited it abit because the 2 cbo's are on my main form and the search is from a popup form.... stLinkCriteria = "[CatCODE]= '" & Forms![frmMainData]![CatCODE] & "' Or [CatCODE] = '" & Forms![frmMainData]![CatCODE2] & "'"

Can someone tell me how to set the linkCriteria to search on 2 different cbo's I'm tring to bring up all records that have what a user selects, in either of the cbo's. Just so you know, a record will never have the same value in both cbo's. stLinkCriteria = "[CatCODE]=" & "'" & Me.CatCODE & "'"...

I use a fairly simple method to send emails out with my db. I also use it for tasks assigned. You can take a look at how I do it. Its not 100% what you need but it grabs the user networkID on the main form, plus I use the ID & email address for a cbo on the task form. Take a look.....

Do you use a network where your users logon?

You need something like: Resume Next: at the end of your code..... I also use On Error Resume Next before the code in case the email gets canceld...

I converted to 97

Heres what I have so far. It creates the sub folder under UPC but its called "-1" not what folder the name I need it to be. Public Sub CreateDirectory(sPath As String) On Error GoTo DirectoryError Dim sPathPart As String Dim i As Integer If Right(sPath, 1) <> "\" Then...

You can open both reports and use the On Activate for the one you want to get the data from have access minimize that report.

I've seen many replies about this were everyone says sql is slower...

First off I want to say thanks for your replies thus far. No, I did'nt try your code, I read it and tried to make sense of it though. If you don't mind I'd like to spell out what I'm trying to achieve. On our network drive employees must keep their project files in 2 different folders. These 2...

Sure I searched this site, spent a bunch of time doing so. Thats how was able to get to the point I am now. I dont understand vb very much. Just enough to get me in trouble. The below code works for me when I create the 1st folder but I dont understand how to reference the folder just created in...

Can you post a sample db .....