Search results for query: *

I have an SQL db hosted on godaddy. I need some of my table fields to handle both English and Chinese characters. I have imported some table data with both languages but the Chinese shows up as a bunch of (??????) question marks. Is there a setting I'm missing to make this work? My fields are...

I've created a website in visual studio 2005 that access a database and allows users to view, add, change, and delete data. I've hosted the site on godaddy - I realized that i had to import my database tables into the database i created on godaddy - now i need to change my connection string to...

I've set up to GridViews on my page - 1 receives a parameter from a previously clicked page the other receives a parameter from the first GridView when a row is selected. The second one does not work. I think the reason is I do not have a mechanism for firing the data source for the second...

I'm using GP 8.0 and have gotten a message that "this company's database size is 1.90 GB. The limit is 2 GB. Remove history from your company, ... etc." I tried using the SHRINKDATABASE function to reduce the size of the DB and eliminate the message but it didn't work. What else can be done...

I'm trying to create an ASP website that displays data from an access database. I have been able to get the data but I also want to be able to write changes back to the table. I have the edit option checked in the grid view properties but apparently there isn't any underlying code to write back...

I'm trying to create a drag and drop like environment on a form. I created a borderless form that is opened and passed the vlaue of a control on another form when the mouse button is pressed. I'm stuck on how to get the borderless form to follow the mouse and then deposit (or drop) it's stored...

I have written a program that gets a file path and puts it in an access table field that is formatted as a hyperlink. I want to be able to use the hyperlink to open the file. The data in the field looks and behaves correct (it's formatted correctly and the pointer turns to a finger when hovered...

I'm trying to create (without much luck) a SUB that can calculate a running balance grouped on a unique part number. For instance, part number 1234 has three records in the table - for each record i want to be able to calculate a running balance so: record 1 Qty 50 Balance 50...

I'm running GP 8.0 and am having difficulty accessing GP data. This wasn't a problem until we did the upgrade to 8.0. When i make the connection i don't get a complete list of tables only those for things like INFORMATION SCHEMEA. Is there a problem with my ODBC connection? I only have a...

I'm running GP 8.0 in a server/client environment lately i have installed GP on a couple of machines and found that the back order document type is not available in the sales transaction window. In the drop down list the option just doesn't show. I though maybe this was a security issue but it...

Ok I've got a strange thing going on with GP 8.0. All data is saved on the server and we have several clients accessing it. On a few machines we do the install - the program sees the server and even accesses the data but doesn't show the company name in the drop down list. Also in the sales...

I want to create a function that will look up a date in a table to find out if it is a working day, holiday, weekend, or shut down day. If the date is anything other than a working day I want to return a date that is the first working day prior to the date in question. Any suggestions? Thanks KT

Is there a way to reprint a posted invoice other than by making a historical copy?

Is there a way to print invoices in batches rather than individually? What I would like to do is print a picking ticket at order entry time and then go back later and print a batch of invoices and packing lists for completed orders. Thanks for the help... KT

I want to create a chart on an access form from data I'm pulling from a table using an SQL statement and I'm totally lost. The form allows the user to select year and quarter combinations to view performance data. What options do I have for creating the chart? Is there an object I can assign...

Hi, Can't see the problem with this piece of SQL statement but my query keeps crashing when i try to use it. strSql = strSql & "HAVING(((DatePart('" & "q" & "',[MainQA_Log]![Date]))=1 AND ((DatePart('" & "yyyy" & "',[MainQA_Log]![Date]))=2004)) " Any ideas? KT

I have created a custom date function in an access database. I'm using the function in an access query and it works fine - however if i try to pull the information into excel through MS Query i get an error "function not defined" apparently this has to do with the ODBC connection. Is there...

i want to create a function that takes a "yymmdd" date format and changes it to a "ddmmyyyy" format. I need to make a four digit year in order to differentiate between 1900 and 2000. I have created a function that brings in the "yymmdd" data as a string - changes it around to the correct format...

Hi! I'm trying to create a chart based on 1 - a selection of data contained on a sheet and 2 - criteria a user can enter about the data - like a specific category and date range. so the user chooses a category from a drop down list - enters a data range (1/2004 to 12/31/2004) - then clicks a...

I want to create a query table in excel from an SQL statement based on an access table. I have a combo box setup on a worksheet for the user to select criteria (customer name) that the SQL statement will use to filter the data. Each time the user changes the selection in the combo box the query...