Search results

Hi I am trying to build a PIPE delimited file with no double quotes. I created the specification file and selected <none> for the text qualifier but it will still put it around the fields that have a comma. I can't have it around any field and I do not see a setting to make sure it is not in...

I set up a report that is opened from a form that has Unbound check boxes. The checks are used in my code to hide or show the relative controls on the report. Also I coded the Detail section "On Format" event to calculate the spacing for when a Control is not selected to be shown...

I always thought it was good practice to group similar variable together on a line (within reason). eg Dim std20, std40, HC40, HC45 As Boolean I just discovered that the above does not work. I have check boxes and for example if I uncheck the std40 & HC45 the variable results are as...

I have searched for this, but can't find a solution that works. I have 3 combo's all of which were created the same way, the 3 were added at a later time. When I added them I used the format painter to copy over the same "Look" of all the colors... well only the first of the 3 keeps the color...

Hi, thanks in advance... I have a main form with a subform, on the sub I have a button to bring up another form to make some selections which enter the data to the subform in one action... so this works perfectly... My issue is I also add Modify options so after the user makes their initial...

I need to read each record and loop it based on the quantity field, so if a record has a quantity of 3 then the record needs to be duplicated 3 times. The reason I am doing this is because I need to add a serial number to each line. this is an order file and I am creating a label file with a...

I hid this table previously, then went to Navigation options to add the check back beside the table, but it won't show... I checked the whole list in case it popped up in another group, so then I went back to navigation options to show hidden objects, and there it is, but still grayed out.... so...

Hi, K, I have this Database that I setup last year and I know it was working, but I just looked at it again yesterday to start working on it again and here is my issue.... Access 2007 now on windows 7 ( previously 2007 on XP)... just mentioning that because its the only thing that changed...

Kinda confused, can someone help me with this.... For Each fld In db.TableDefs("tblLabelFile").Fields FldNme = fld.Name FldNme = "rs!" & FldNme the above tells me the field name, which I then want to...

I have searched Hi and low, and I see many people have this issue, but I can't seem to fix it. I first create my Text file by exporting as a CSV with no field headings, I need Pipe delims so I edit the csv and replace comma with Pipe delim… so I then import that file and create my spec, I have...

Hi I'm using the Openreport method, and using a text box to control copies, how can I get the copy number to show on the printout for each page printed?

I have 2 tables linked in a query..... TransActionDate REC-ClosedDate 26-May-10 27-May-10 27-May-10 27-May-10 #Error 27-May-10 #Error 27-May-10 #Error 27-May-10 #Error 27-May-10 #Error 27-May-10 27-May-10 27-May-10 27-May-10 [ProductMovement] is the main table and the join is set to...

I have a field that is really giving me a hard time, the data is query from main system, but has the wrong data type...it comes to me as text, and I need to convert to number....this normally isn't a problem for me, but this case is wasting my time... I've tried so many combinations... I use a...

Here's the situation...in case another method can be used.... I'm selecting records in a combo, and in the Before update event I am checking for duplicates.... when one is found it triggers a message and I cancel/undo to clear the selection...I am then trying to send the ESCAPE key to, what I...

Error: Syntax error in INSERT INTO statement I have this VBA to create an SQL string, it worked but I added a new field to my table but I can't get it to load. The new Field is: option it is a Text data type in the table. strSQL = "insert into...

I set this code up to load a table based on beginning ending dates, I thought it was working...then I realized is I enter a begin date where the DAY is a single digit ( 1-9) it mixes it up as a month so where Dec 1/09 is entered it turns it into Jan 12/09? Seems basic, and I'm being lazy by...

I know the Week number, Day of Week and Year ( it is a production batch Expiry) eg Week= 24 Year = 09 Day of Week = 5 I want to convert to a date, but I need to work backwards. So The day of the week relates to the week number which is important when a week overlaps 2 months. Any ideas...

I'm trying to create a "Pipe" delimited text file using the Transfertext method. what I have done so far is I Exported as a standard "Export Delimited" which creates a CSV. I then used a text editor and Replaced the Comma's (CTRL+H) with the Pipe | .... and also replaced the Quotes with...

ok maybe I'm having a bad day, I have had 2007 for a few months and I usually muck about and find everything I need, but every once in a while I get thrown a curve ball, and possibly through frustration dig myself into a hole... I just spend about an hour trying to get my report to group...

Hi I'm having trouble displaying time, Access is taking my time and adding the date to it...as Jan 1 1900 What I am doing is taking a selected date ( from form), and then for that date I am generating time slots using a starting value of 7:30 and adding 1 hour by looping 15 times. visually in...