Search:
Type: Posts; User: Granty
Search:
Search took 0.12 seconds.
-
Have you tried creating a new query, switching to SQL view and then adding your SQL (the output version). You can then switch back to the query definition view and often it shows where the problem is.
-
I assume this is Access? If so, here is a link to the explanation. I generally use the .value to avoid having to set the focus but there are some caveats explained in that link you need to be aware...
-
Its been a long time since I used it but you should be able to find your table in msysobjects and then remove it in the same sort of way as a query, but by manipulating the Tabledefs collection.
-
When the LOC_ID is duplicated, are all the other fields dupicated too, or do they have different data?
e.g. for (LOC_ID, Otherfield1, Otherfield2)
Is it:-
1 ,Blah, Rhubarb
1, Blah, Rhubarb
...
-
Is 'account' always the same length? If not your solution might cause problems later.
Try SUBSTR(ACCOUNT, -5) (that seems to be the general answer to this looking on the web).
J.
-
Can you post the code as you have it now?
-
Do you _have_ to push from Excel or can you possibly pull from Access instead?
-
I'm not really sure what you are trying to do here, could you try and explain it a bit better?
-
Try changing:
wb1.Sheets("NewIncident").Copy
To:-
wb1.Sheets("NewIncident").Range("A1:Z50000").copy
Replace the range numbers with the actual range you want ofc :)
-
Not sure what database you are using but something like...
SELECT [Source of information], MONTH([Contact Date]), COUNT(1)
FROM [English Students]
GROUP BY [Source of Information],...
-
You have it backwards.
You have it that you get a list of room-bookings which don't overlap the given times. In your example, room 1 is in that list because the 3rd record is returned by your...
-
Isn't the 'true' parameter in your TransferSpreadsheet the HasFieldNames option?
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, _
"Contributors Who Donated in Past Week",...
-
There is also the TimeGetTime() API function which is very accurate
-
Seems I can create a simple view in the PG database that has the SQL:
Select * from myFunction()
and then link my pivot to that through the odbc connection. This seems to work so far....
-
Hi all,
In the past, I have often created Excel Pivot tables for my users that use an external data connection to get the data from SQL Server. Often, the process to create the required output...
-
Hi all,
I have a MI workbook in Excel 2003 that has a lot of pivot tables and graphs. However there are only 4 separate master pivot caches and the rest are just based on those.
The data source...
-
Of course I can :blush:
I was so wrapped up in messing around with the access side I forgot all the things I could do server side....
It's been a long day (and Im sticking to that excuse)
...
-
Hi clever people,
I'm trying to return data from a SQL Server SP to a local Access database and insert it into a table. This is usually no problem but I have to pass a couple of parameters from...
-
Try changing to:
If ActiveCell.Value = TempO Or ActiveCell.Value = TempA Then....
-
Rename your textboxes to txtUserName and txtPassword and try that - I have a feeling UserName and Password are reserved properties.
-
Thanks Westconn1 that works great!
Would have taken me ages to find that ref path, cheers for the time-save :)
J.
-
Hi all,
quick one (hopefully).
Unfortunately Im forced at this place to use Excel (ugh) for a bit of development.
I have stuck a couple of buttons on a standard excel sheet (not a userform -...
-
I didnt think of doing it that way!
Works perfectly, thanks anhn :D
-
Hello folks,
been a while since I coded and I'm rusty :blush:
On an access form I have 4 boxes. From my database I have 4 strings. How to randomly put the 4 different strings in the 4 different...
-
Are you just trying to add the data to the new table or are you trying to add the selected field (and all its data) into a table that doesnt yet have that field?
-
There are a few different ways all using either CAST or CONVERT to remove the times - CONVERT has some inbuilt "styles" for dates that should work.
...
-
Hi all :)
I've started working in a new contract as a data integrity analyst. The system I'm working on is pretty big, and also full of really bad data.
e.g. Lots of child records where the...
-
Hi all,
I have to import a text file into my SQL Server database via DTS. This is usually no problem, but I am getting an error "Column Delimiter not found". I looked up on MSDN and it said I...
-
Inner joins are fine, it is far more likely to be your database structure that is the problem.
-
If there are any duplicate values in any of the following, you will get duplicates in the result:
tblQuote.Contact
tblContact.Contact1
tblCustomer.Address1
-
I replied with a bit of info in my first post (after yours). Did you need more help?
-
To be honest Hack, I cant even remember what I was trying to do, let alone how I did it! I've changed jobs twice since I posted this question.....
I'll have a think and if I remember Ill update.
...
-
Wow, thats one hell of a delayed reply! ;)
What exactly are you trying to do? You should use the DTS to import a CSV and then save the package. You can edit the package from VB if you need to...
-
Cheers brucevde (was hoping you would see this thread) I'll read up that stuff and get back to you.
J.
-
Hi all,
I used SQL server a lot at my last company but have now moved to a new company. Atm here all they have is access which is nowhere near large enough for what I need to do. So Ive been given...
-
How do you mean Input Mask on a table?
I thought Input Masks go on textboxes....
MyTextBox.InputMask = "(###) ###-####"
-
Ack! Sorry Brenda, I only just realised you are using .NET which probably explained why my code on page 1 is not working :blush:
-
Have you tried the 2nd way but without quotes around the True and False?
-
Modify in what way? And how are you presenting the data to your user?
If your controls are bound to the recordset then you are stuck I think. If you populate them yourself then you should be able...
-
I think the CASTs have to go on each Bit field.
SELECT (CAST(Electric AS Numeric) + CAST(Gas AS Numeric)....etc
|
Click Here to Expand Forum to Full Width
|