Search results for query: *

I'm trying to import Outlook contacts from an Access table. Everything seems to come accross fine except for the Notes field. I've set it up to map to the correct column in the Outlook import. I've tried to import it with the Access database using that column as a Memo field and Text field...

I was never able to find a good solution. What I ended up doing was creating a button in my eVB application that deleted all the info in the tables I didn't want to carry on my PDA. It's an extra step the user has to take after they sync but it's the best I could come up with. I think you...

I have a eVB application I created to run on Pocket PC. Using activesync I can sync my pocket access to my Access database on my desktop. The problem is I don't want everything to sync. Some items I just want to be copied from the pda to my desktop. For instance, while in the field I gather...

thanks for the help Jim. I actually solved the problem. On the page setup there was a checkbox checked that said Print Data only. I guess that was making it so no labels anywhere on the report would print. I've never noticed that check box but thankfully I found it now. Thanks for the help...

Thanks Jim...all of them are set to Visible=Yes. I've never seen a problem like this so it is really confusing me. I've checked out all of the properties for the labels, pageheader and report and can't find anything out of the ordinary. Any other ideas? Thanks, Brian

I'm printing a report with headings in the page Header. They are just standard label fields. The problem is the labels do not appear on the preview or printed forms of the report although they are there in design view. I've tried adding new labels to every section of the report and none of...

Thanks guys, I couldnt' get it to work replacing with %27 but the "''" worked. Thanks again. Brian

I'm having problems passing values entered into a form to my Access backend. It works fine unless a single quote is entered into the form. i can't seem to get the sql string correct. any help would be aprreciated. I've tried the following: sql = "UPDATE tblEmployees SET" sql = sql...

I encountered this error once. In my case the file was corrupted beacuse of software installed on my laptop. In my case I had Visio 2002 installed which updates a VB dll. Occasionaly this caused the db to corrupt. Microsoft's response was to revert to the last backup copy. Once you get that...

Are you talking about a Flowchart?

Thanks for the reply Jim. What version of Access are you running? I'm on 2000 and I found on the MS website yesterday that it's new in 2000 that you have to have exclusive rights to create an object(report, form...) It stated that it trys to promote your lock to exclusive but I couldn't...

I have to agree with Terry. I have the 2000 Desktop and 2000 Enterprise versions and both have proved to be very helpful. They also come with a CD that demonstrate all of the examples they use. Brian

I have a 3 user database running on a Novell network. 2 system are running Win2000 and the other Win98. The database resides entirely on the server (not split at all). I've created a report writer that opens a new report in design mode and saves the report. I recently learned that you...

I have a 3 user database running on a Novell network. 2 system are running Win2000 and the other Win98. The database resides entirely on the server (not split at all). I've created a report writer that opens a new report in design mode and saves the report. I recently learned that you...

Thanks for the advice Ed. I think I'm definitely going to start using unbound forms fron now on. Seems like it will give me a lot more control. Thanks.

The locks are set to No Locks. Which I think I need since I'm changing the same record from another form. I've decided to change the layout so that all data is contained on the one form. Doesn't look as nice but it's the best solution I could come up with. Thanks for the help. Brian

I've seen a lot of answers to write conflict issues but nothing that has helped me so far. I have a form (Form 1) bound to a table (Table A). I also have another form (Form 2) that can be opened at the same time that has a recordset based on Table A. If I update the recordset through Form 2...

Thanks Jerry...I was starting to think that if couldn't be done at runtime. Everything worked great. It is pretty fast (barely see the screen flash when it changes the subreport). Thanks, you saved me a lot of headache. Brian

I'm having a problem filtering a subreport. The subreport is not connected to the main report (by that I mean the link child and parent fields are empty). If I set the Filter property of the subreport in the properties box the filter runs fine. The problem is I need to filter at runtime so...

I actually found a way around it that will work for now. I created 2 listboxes on the form. The first was set to a query that selected the first 50% of the records. The second was setup so it selected the remaining records. It only gives me 2 columns but it's better than 1. Thanks for your...