Recent content by jchim32

I am looking for a way to create a web form where a user can input information into the form, submit the data and a PDF is created with the data in barcode format where they can then print out this PDF. Any ideas? Thanks!!!!!!

Hola Access gurus, I have been tasked with creating a proposal generator for our sales force and have run into some roadblocks. I have created a form that populates a word template using bookmarks. I have a subform that will have 9 combo boxes that I need to populate the word doc but I need...

First server up and running, DOMAIN.COM, DNS installed and working with Allow updates ON. Problem when I attempt to configure the 2nd server as a child within that domain. 2nd server's DNS points to first server. Here are the steps I get through before the error: 1. Domain controller for new...

Dan, Thanks for the reply. The IPX networks are in the format of 12AB3C4D. In your 2nd response you posted what looks to be the exact code I am looking for, only thing is I am not too saavy on VB. Can you explain how I can build this into my form, creating a field in design view and when and...

I am looking for a way to convert an IPX Network Number (HEX) to IP (Octet) in my Access form. Anyone have any ideas on how this can be done? Thanks, Jeff

Dale, That worked like a charm, thx

I have a database where I am linking to excel spreadsheets. The columns that are numbers show up in Access as #Num! unless the number is a "Number stored as Text". Anyone know how to correct this in Access or how to convert the entire column in excel in one shot rather than having to...

I have an excel spreadsheet that I would like to convert the entire column of numbers to 'Numbers stored as Text'. In my research, I have only found how to convert it the other way, from Number stored as Text to Number. If anyone knows how to convert the entire row, please let me know. TIA, Jeff

Anyone know the procedure for converting HEX to Octet in a form? Any help is appreciated. TIA, Jeff

I'm looking for a way to add default text to a field in a form. This data is not in any of my tables, I just want to be able to add the text such that this field always has the same text included with the output. For example, I have a field FirstName. When I search for data in the form, I...

Thanks for the posts. After hours of hunting last night for the solution I was able to figure it out. I have never created a form using Design View, which was similar to what I was trying to do here. The steps that ZylaWonder posted were close to what I did to get the results I was looking for.

Where is the SELECT statement exactly?

I've created a form but now I want to add a field to the existing form. I've attempted to use the expression builder in Design View but it returns #Name? The field that I want to use does not show in the FIELD LIST because it was not a field I included when I created the form (using the...

Yes, it's a form. I am using this form to search for the data. The data is spread across 6 different tables. If one of the tables does not contain the common information (Building ID), it returns nothing at all. I would like to have it at least return the information from the other 5 tables...

Thanks for the reply. It's not a query, its a form with relationships that I have established. Here is an example: Table 1 has Building ID (which is used as the common link between all tables) and several other colums. Tables 2-6 also have this info but if the building ID is not found in...